reports???

[sparky2005]

Is it possible to add fields from multiple querys and show them in a report???

B4 u answer..... i wil explain! I basically have 2 tables
1. Restaurant Bookings
2. Hotel Bookings

I have made 2 querys (one for each) which basically display all of the breakfast, lunch or dinner bookings and times for each for a certain date (which i type in as a parameter)

My problem..... I dont want to have 2 seperate lists for the dinner etc i want all the records for the dinner bookings to be displayed on the same report but from both querys?

How could i do this?

Hopefully u cud let me know.....

Cheers

 

[gromit]

You can make a summary query that uses the 2 existing queries as inputs. I.e. just the same way that you used a table as the basis for a query, you can also have the query used as the basis for a new query.