Creating a report to merge 2 queries

I have created 2 queries. They both have the same field names. Date,
Platform, Platform count. When they open up the report they put the date in
and they get how many entries per platform for each group. The problem I am
having is how do I get them to merge together to get a total without
duplicating if there is nothing on that platform for that day?
I tried to create another query but since the fields were the same I didn't
know what to call it or how to build a sum field. The 2 queries are Com and
Rph
there are 4 platforms and I need them to show seperate but also sum at the
end.

On Thu, 2 Jul 2009 16:01:01 -0700, LG wrote:

I have created 2 queries. They both have the same field names. Date,
Platform, Platform count. When they open up the report they put the date in
and they get how many entries per platform for each group. The problem I am
having is how do I get them to merge together to get a total without
duplicating if there is nothing on that platform for that day?
I tried to create another query but since the fields were the same I didn't
know what to call it or how to build a sum field. The 2 queries are Com and
Rph
there are 4 platforms and I need them to show seperate but also sum at the
end.

Take a look at the Help for UNION. I suspect you need a UNION query to string
the two queries together.
--

John W. Vinson [MVP]

To add some to John's answer, here is a tutorial on Union Queries, written
many years ago by a colleague at my place of work (as evidenced by the
data!!).

http://www.accessmvp.com/TWickerath/...ionqueries.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"John W. Vinson" wrote:

On Thu, 2 Jul 2009 16:01:01 -0700, LG wrote:

I have created 2 queries. They both have the same field names. Date,
Platform, Platform count. When they open up the report they put the date in
and they get how many entries per platform for each group. The problem I am
having is how do I get them to merge together to get a total without
duplicating if there is nothing on that platform for that day?
I tried to create another query but since the fields were the same I didn't
know what to call it or how to build a sum field. The 2 queries are Com and
Rph
there are 4 platforms and I need them to show seperate but also sum at the
end.

Take a look at the Help for UNION. I suspect you need a UNION query to string
the two queries together.
--

John W. Vinson [MVP]