Union Query

[jlclark4]

Good Afternoon,



Is it possible to join different fields from the same table?

RootCause, SubCatA, SubCatB
RootCause2, SubCat2A, SubCat2B
RootCause3, SubCat3A, SubCat3B

They all contain similar data. In the form, chocies for sub cat is populated based on the root cause selection.

Any ideas?!

Thanks

[RuralGuy]

Maybe this will help: http://allenbrowne.com/ser-06.html

[jlclark4]

I looked, It doesn't seem to be what I am looking for. I just want to populate a list using a query where RootCause,RootCause2, and RootCause3 are all listed in one field. Then SubCatA, SubCat2A, and SubCat3A are listed in one field together. Then SubCatB, SubCat2B, SubCat3B are in one field.

[RuralGuy]

In that case maybe this link is what you are looking for: http://allenbrowne.com/func-concat.html