Query over 6 tables 1

[RJMacReady]

I have 6 tables that represent sales for 6 performances of "The Most Happy Fella." The fields are:

seat
seatID
status
transactiondate
price
customer
paymentmethod
checknumber
memberid
customerID
member
paymentID

Essentially, I need to be able to create a report that will include all 6 tables' data and be queried by transaction date. I have created 6 different queries, 1 for each table, is there a way to combine them? In retrospect, it would have been a helluva lot easier if all 6 were combined into 1, but this is where I am. Any ideas? Thanks in advance.

 

[SteveR77]

If the six table are set up with the same field layout you could create a table called Master and run an append query for each of your six tables to append the data to the master table then run your query off that.


HTH,

Steve