I have created a database to track employee time. Within that, I have
also created a report off the following query:

SELECT ALLTasksFilter.ProjectName,
Sum([qryDateFilterTaskHours-Daily].NumberOfCompletions) AS
SumOfNumberOfCompletions,
Sum([qryDateFilterTaskHours-Daily].HoursWorked) AS SumOfHoursWorked,
[qryDateFilterTaskHours-Daily].WorkedByWho
FROM ALLTasksFilter LEFT JOIN [qryDateFilterTaskHours-Daily] ON
ALLTasksFilter.ProjectName = [qryDateFilterTaskHours-Daily].ProjectName
GROUP BY ALLTasksFilter.ProjectName,
[qryDateFilterTaskHours-Daily].WorkedByWho;

The Report displays the Task Name, how many completions, and how many
hours.

The report shows ALL tasks, even those that do not have any completions
or hours attributed. Right now, the report shows a blank if there is
no reported completions or time. Is there any way to make it show a
"0" if not time has been documented?

The Pseudocode of:

If [Number of Completions] is null,
Then Me.Number of Completions = "0"

I have created a database to track employee time. Within that, I have also created a report off the following query:

SELECT ALLTasksFilter.ProjectName, Sum([qryDateFilterTaskHours-Daily].NumberOfCompletions) AS SumOfNumberOfCompletions, Sum([qryDateFilterTaskHours-Daily].HoursWorked) AS SumOfHoursWorked, [qryDateFilterTaskHours-Daily].WorkedByWho FROM ALLTasksFilter LEFT JOIN [qryDateFilterTaskHours-Daily] ON ALLTasksFilter.ProjectName = [qryDateFilterTaskHours-Daily].ProjectName GROUP BY ALLTasksFilter.ProjectName, [qryDateFilterTaskHours-Daily].WorkedByWho;

The Report displays the Task Name, how many completions, and how many hours.

The report shows ALL tasks, even those that do not have any completions or hours attributed. Right now, the report shows a blank if there is no reported completions or time. Is there any way to make it show a "0" if not time has been documented?

The Pseudocode of:

If [Number of Completions] is null, Then Me.Number of Completions = "0"

GROUP BY ALLTasksFilter.ProjectName,
[qryDateFilterTaskHours-Daily].WorkedByWho;

The Nz function converts null values to a specified value. For
instance, Nz(YourFieldName,0) would report any null values as zero. By
putting this inside your sum function, you are converting the nulls to
zero BEFORE it tries to sum them up. BTW, this works for all data
types, so long as your specified value matches the data type of
YourFieldName. If it is a string field that is null,
Nz(YourFieldName,"Blank") would spit out the word Blank.