Need to display all names, even those with no entries

[DANANDLEA]

I have created a small database to track overtime. I have a table set
up for employee information, one for entry of overtime (which happens
via a form). I need to create a report that lists all employees by
shift, regardless if they have worked overtime or not, but include the
sum of overtime for those that have worked. I can currently only
query those that have worked - any way around this?

 

[Guest]

Post the SQL of your query so we can see what it is doing now.

 

[obriend]

SELECT Sum([TIME WORKED].[HOURS WORKED]) AS [SumOfHOURS WORKED],
[Employee list].NAME
FROM [Employee list] INNER JOIN [TIME WORKED] ON [Employee list].ID =
[TIME WORKED].ID
GROUP BY [Employee list].NAME
ORDER BY Sum([TIME WORKED].[HOURS WORKED]);

 

[Guest]

Change your INNER JOIN to a LEFT JOIN
--
Dave Hargis, Microsoft Access MVP

SELECT Sum([TIME WORKED].[HOURS WORKED]) AS [SumOfHOURS WORKED],
[Employee list].NAME
FROM [Employee list] INNER JOIN [TIME WORKED] ON [Employee list].ID =
[TIME WORKED].ID
GROUP BY [Employee list].NAME
ORDER BY Sum([TIME WORKED].[HOURS WORKED]);

 

[obriend]

THANK YOU VERY MUCH! THAT WAS SUCH A SIMPLE FIX

Change your INNER JOIN to a LEFT JOIN
--
Dave Hargis, Microsoft Access MVP

SELECT Sum([TIME WORKED].[HOURS WORKED]) AS [SumOfHOURS WORKED],
[Employee list].NAME
FROM [Employee list] INNER JOIN [TIME WORKED] ON [Employee list].ID =
[TIME WORKED].ID
GROUP BY [Employee list].NAME
ORDER BY Sum([TIME WORKED].[HOURS WORKED]);