Displaying Null Value in a query from two tbl

[dannyxx]

Hi everyone, I'm new in access and trying to make my first database.



I have a tblEmployees ( tblEmployees.CustomerID, tblEmployees.FirstName, tblEmployees.LastName )

This table is related to tblHours (one to many)

tblHours ( tblHours.CustomerID (from tblEmployees) , tblHours.ProjectID (from another tbl) tblHours.Hours


Now I created qryHours where i have

tblEmployees:

CustomerID group by
FirstName group by
LastName group by

tblHours:

Hours group by sum


The problem I have is, there are some employees that didn't work yet and I want that in qryHours their Hours value will be zero. Because now I can't even have them in the qryHours as they don't have any worked hours.

Any Suggestion Please?

[dannyxx]

Found answer here: http://www.utteraccess.com/forum/sho...html&p=1964936

Thanks everyone

[ItsMe]

Thank you for letting us know you have solved the problem. Welcome to the forum.

[dannyxx]

thank you too! My english isn't that well but I found already many good staff here on this forum!