Unmatched query help

O

Opal

Running Access 2003, I have the following query as a
basis for a chart I run on a report:

SELECT Count(Review.RevID)
AS CountOfRevID, Review.RDate, Review.SupLink,
[FirstName] & " " & [LastName] AS SupName,
Format(Day(Weekday([RDate],1))+1,"DDD")
AS DayofWeek
FROM Review INNER JOIN SupInfo
ON Review.SupLink = SupInfo.SupNumber
GROUP BY Review.RDate, Review.SupLink,
[FirstName] & " " & [LastName],
Format(Day(Weekday([RDate],1))+1,"DDD")
HAVING (((Review.RDate) Between
[Forms]![HoldingInfo]![TxtReportEndWeek]
And [Forms]![HoldingInfo]![txtReportDate]));

Each Supervisor (Sup) is required to perform one review per day.
I have 5 charts on my report (one for each work day) but I can
only see which Supervisor recorded his/her review. I want to show
all Supervisors so the the person viewing the report can see which
Supervisors are NOT doing their reviews as well. I thought I could
create an unmatched query, but I don't get the desired results.

Can anyone point me in the right direction?
 
P

PieterLinden via AccessMonster.com

Opal said:
Running Access 2003, I have the following query as a
basis for a chart I run on a report:

SELECT Count(Review.RevID)
AS CountOfRevID, Review.RDate, Review.SupLink,
[FirstName] & " " & [LastName] AS SupName,
Format(Day(Weekday([RDate],1))+1,"DDD")
AS DayofWeek
FROM Review INNER JOIN SupInfo
ON Review.SupLink = SupInfo.SupNumber
GROUP BY Review.RDate, Review.SupLink,
[FirstName] & " " & [LastName],
Format(Day(Weekday([RDate],1))+1,"DDD")
HAVING (((Review.RDate) Between
[Forms]![HoldingInfo]![TxtReportEndWeek]
And [Forms]![HoldingInfo]![txtReportDate]));

Each Supervisor (Sup) is required to perform one review per day.
I have 5 charts on my report (one for each work day) but I can
only see which Supervisor recorded his/her review. I want to show
all Supervisors so the the person viewing the report can see which
Supervisors are NOT doing their reviews as well. I thought I could
create an unmatched query, but I don't get the desired results.

Can anyone point me in the right direction?
Click to expand...

Create an outer join between the Supervisor and the Review in your query.
Select the option to show ALL records from the Supervisor table and MATCHING
from Review.
 
Top