1 table, 3 queries, 1 report

J

Jessaudrey

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
 
R

Rick B

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.
 
J

Jessaudrey

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?
 
R

Rick B

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.
 
J

Jessaudrey

I will try the union query. The queries all have the same named fields only
one table.
Thanks
 
Top