I have two tables; one that contains time spent on projects by resource and the second is a master list of resources.
I have a query that relates the two tables with the Resource ID where it includes all records from tblListResources and the related records from tblProjectHours:
Joe Project A 15
Joe Project B 15
Jane <No Time Tracked>
Frank Project B 25
When I pull the hours in to the query and run the report, any resource that did not complete their time displays a #Error message in the hours field. Instead I want to display a zero if they have not filled in hours.
I tried the nz function: Hours: nz([sngHours],0)
But still get the error.
I have a query that relates the two tables with the Resource ID where it includes all records from tblListResources and the related records from tblProjectHours:
Joe Project A 15
Joe Project B 15
Jane <No Time Tracked>
Frank Project B 25
When I pull the hours in to the query and run the report, any resource that did not complete their time displays a #Error message in the hours field. Instead I want to display a zero if they have not filled in hours.
I tried the nz function: Hours: nz([sngHours],0)
But still get the error.