View all info from both queries but with links

[hartwell]

Hi,

Im trying to view all info from both tables with links so if one table doesnt have a record the other will still show and visa versa.

Im looking at a call centre and the times calls come in grouped by half hour(1nd query) and number of people signed on grouped by half hour (2nd query). Link on the date and Half hour slot is a must. I can only get them to show 1way or the other, not both at the same time (need to show all due to running Sum in report)..

Example of what im getting:

Query1 Call Volumes
09:00 20
09:30 22
10:00 20
11:00 15

Query2 SignedOn

08:30 2
09:00 4
11:00 2

Results:

Either:
Time Vol Signedon
09:00 20 4
09:30 22
10:00 20
11:00 15 2

Or:

Time Vol Signedon
08:30 2
09:00 20 4
11:00 15 2

Here is the sql for showing all call volumes

SELECT qry_EBFHO_RBS_HalfHour.*, qry_Signed_On_Count.*
FROM qry_EBFHO_RBS_HalfHour LEFT JOIN qry_Signed_On_Count ON (qry_EBFHO_RBS_HalfHour.TERM_DATE = qry_Signed_On_Count.DATE_STAMP) AND (qry_EBFHO_RBS_HalfHour.HalfHour = qry_Signed_On_Count.HalfHour);

 

[PHV]

Have a look at UNION query

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hartwell]

Sorry dont see how UNION will help in this situation

 

[PHV]

dont see how UNION will help
A starting point:
SELECT A.Time, A.Vol, B.Signedon
FROM Query1 AS A LEFT JOIN Query2 AS B ON A.Time = B.Time
UNION
SELECT B.Time, A.Vol, B.Signedon
FROM Query1 AS A RIGHT JOIN Query2 AS B ON A.Time = B.Time
WHERE A.Time Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886