I believe the answer to my question may be a union query but I am not sure how to create.
I have three groups of data that all need to be pulled together into either a master table or query since it needs to all reflect the same data.
How can I take table A, B, and C and pull together the difference pieces into one query but still maintain the tables. I want to be able to update the table and have the group query follow and vise versa.
Does this make sense?
If I use a union query do all my headers need to match?
I have three groups of data that all need to be pulled together into either a master table or query since it needs to all reflect the same data.
How can I take table A, B, and C and pull together the difference pieces into one query but still maintain the tables. I want to be able to update the table and have the group query follow and vise versa.
Does this make sense?
If I use a union query do all my headers need to match?