list distinct values from multiple fields

[pbuethe]

I have 4 status fields in one table. I was wondering if there is a way to list every different value from all 4 fields in one column. Thanks for your help.

 

[EMP]

You can pull the four fields together in a Union query:-

Select [Field1] as [Distinct Values] from [tableName]
UNION
Select [Field2] from [tableName]
UNION
Select [Field3] from [tableName]
UNION
Select [Field4] from [tableName]

 

[pbuethe]

Thanks EMP. It appears to work.