HillTJ
To train a dog, first know more than the dog..
- Local time
- Today, 01:25
- Joined
- Apr 1, 2019
- Messages
- 731
Hi, i have a report with two subreports. Both linked to the main report by a common id. One subreport summarises products, their pricing etc with a query. The other summarises accessories also with a query. The calcs behind each query are different & the queries have different fields (but there are common fields that i need to reproduce in my quote). I'd like to join both queries into a single query so that the main report displays records from 1 consolidated query. The number of records in each table varies. I tried a make table query which sounds promising, but am unsure how to configure it. Any ideas would be appreciated.
Last edited: