access vba courses in london - Acces - Query out of other queries

Hi Carlos,
Thank you for your response. However I'm afraid it didn't solve my problem. Let me try to make my question more clear.

I need to make a report that will show all the outcomes of various queries. The queries I've build have all a calculation of the records with the same City name, since I've created them all by using the 'Group by' option , choosing 'Count'.

This was necessary to get a in Query 1 PER CITY how many x we have. And in Query 2 PER CITY how many y happened. etc.

My initial thought was to create a combined query, but in a way that these calculations of records per city continue to exist.

But everytime I try to combine these queries in a new query the calculation doesn't work.

Would there be another way in getting all these calculations together in one overview.

Could I for instance build a report adding information from the multiple queries? In that way avoiding that I need to make a new Combined query?

I really hope you can help!

Thanks

Adrienne

Hi Carlos

Thank you for your help. In the meantime some one has helped me and showed me the way to do this.

Thanks for the offer though, much appreciated.

Regards

Adrienne