Multiple tables and queries for report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have requirements that require approx 10 queries based off 9 tables (not
all of the same tables in each query) and need to generate a report from
those queries. Because each query will output different results. How do I get
all of these different queries into one report? Do I make a make tbl query?
Base the report off all 10 queries, do update query? Currently I am taking as
many of the queries and joining them together to get the same results in
fewer queries. How will I bring them all together to get the requested
results? Thank you in advance
 
It is according to the relationship of the data. You might just need to
build separate reports for each and then place them in a single report as
subreports.

If they are closely related then you might need to join the queries and us
grouping and sorting in your report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

queries delete themself after i print my reports 1
Query criteria based on table entries 1
Want to edit a table based on a query of a query of several querie 2
Removing Certain Records from a Query and Report 1
Close query 1
Nested or Sub query? 2
Joining results of two queries 3
Total appointments per agent 2

Back
Top