Creating a report to merge 2 queries

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

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.
 
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.
Click to expand...

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