1 table, 3 queries, 1 report

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

Guest

I have 3 queries based off of one table. They each have the same named
fields but some formulas are different. I want to get all three of these
queries into one report. Can anyone help with how to do this and what to use?

Thanks in advance
 
Either create another query and pull each of those three stored queries to
it, or create separate subreports for each query and include the subreports
in your report.
 
If I create another query I have 3 fields with the same thing names only
different queries.

Name Name Name Date Date Date

How do I get this to only list under one heading?
 
Huh? Those would be three different items.

If you are trying to pull all the data together and not differentiate, then
you need to step back and build a UNION or UNION ALL query. See the help
files for more details.

Generally, but not always, your question would suggest a poorly structured
database. In other words, all the data should be in one table, not three.
 
I will try the union query. The queries all have the same named fields only
one table.
Thanks
 
Back
Top