How to display results of multiple queries on one report?
I'm creating a report with 3 source queries. Each source query returns distinct values of the same field name (SkillID). How do I display the distinct results of all 3 queries on the same report?
I'm creating a report with 3 source queries. Each source query returns distinct values of the same field name (SkillID). How do I display the distinct results of all 3 queries on the same report?
Thanks!
CB55
Ehh, just use subreports. Not thinking this morning...
I'm creating a report with 3 source queries. Each source query returns distinct values of the same field name (SkillID). How do I display the distinct results of all 3 queries on the same report?
Thanks!
CB55
Use the "report wizard" to help you build a subset containing all three queries.
Or, click and drag each query to a blank report in design view.
Comment