Combined Query of 3 Queries

  • Thread starter Thread starter Chuck Moore
  • Start date Start date
C

Chuck Moore

I have a table with Staff Names and a table with Shift
Information. For each shift, on related tables, I track
three issues by staff - Code Blues, Code Reds and Code
Whites. Each issue does not necessarily occur each shift
but there also may be multiple occurrences during each
shift of each issue. Each issue table tracks shift ID,
staff ID, start time and duration.

I have separate queries and related reports that show for
each issue, a staff name and the total number of
occurrences. I would like to combine the three separate
queries into one and develop a single report that will
show the totals of each incident by staff name in a single
row for each staff with the incidents as columns.

My trouble is with the combined query. As soon as I
include more than one incident count from a second query
my record counts go crazy.

Any suggestions?
 
If you have the same number of fields on same spots for the
same purposes, you may want to consider using a Union query.

Here's a simple pseudo SQL example:

Select * from Query1
union
Select * from Query2
union
Select * from Query3

Krgrds,
Perry
 
Back
Top