Union Query (1 Viewer)

[Matt Greatorex]

Okay, people. I am getting married in a few days and my mind is on other things. Consequently, I can't get my head around this one.

I have two queries, Query1 and Query2. Both have a different number of fields but they have the field "IA Code" in common.

I want to create a new query containing all rows from Query1 and all rows from Query2. Where the [IA Code] matches, I'd like the information to be displayed in one row.

I think I need to use Union somewhere along the lines, but I can't work it out.

Any pointers/syntax greatly appreciated.

 

[namliam]

If you are sure that one query will contain all records and the other is a subset of the first (or both contain all records) then you can simply join the 2 queries.

If both queries have different datasets, you will need to create 2 "outer join" queries and Union those 2 queries...

I hope it makes sence to you, I know how it feels to get married. I just did so myself little more than a month ago...