Report with same grouping but data from two queries.

  • Thread starter Thread starter Geo
  • Start date Start date
G

Geo

I want to combine the results of two queries on one report with the same
grouping.
The queries are based on two tables with similar information. One table is the
main data and the other is a weekly imported spreadsheet from another source
used as a visual check (read only - two forms side by side with highlighted
differences). The spreadsheet import currently has several thousand records and
our database has several hundred entered from completed questionaire forms
received.

I have created a pair of queries with grouping on Regions (6) with sub grouping
of Depots (about 150) that shows the total number or journeys made.

What I would like to do is combine the two reports to be able to see how many
reports we receive in relation to the total journeys made - something like:-

Region.....Depot.....Total.....Forms received
North East
............Depot1....150.......45
............Depot2.....40........2
North West
etc.

Geo
 
I want to combine the results of two queries on one report with the same
grouping.
The queries are based on two tables with similar information. One table is the
main data and the other is a weekly imported spreadsheet from another source
used as a visual check (read only - two forms side by side with highlighted
differences). The spreadsheet import currently has several thousand records and
our database has several hundred entered from completed questionaire forms
received.

I have created a pair of queries with grouping on Regions (6) with sub grouping
of Depots (about 150) that shows the total number or journeys made.

What I would like to do is combine the two reports to be able to see how many
reports we receive in relation to the total journeys made - something like:-

Region.....Depot.....Total.....Forms received
North East
...........Depot1....150.......45
...........Depot2.....40........2
North West
etc.

Geo
Click to expand...

try using a Union query.
create two or more queries one for each region they have to have the
same fields then combine them with a union

they look like
TABLE InventorySummary_1 UNION ALL
select * from InventorySummary_2 UNION ALL
select * from InventorySummary_3 UNION ALL select * from
InventorySummary_4
ORDER BY [stratumID], [cover] DESC;
 
Back
Top