Is it possible to combine multiple columns of different formats in a single field in a Microsoft Access select query by creating nested IIF statements?

Answer 1

I think you are referencing to case when statements in SQL.

You can create a user defined cols based on the category you want.