Datediff

[greggue]

I created a query that calculates the total number of registrations per week.
I used the dateddiff function to count the number of week from certain date to the registration date.

The issue is that if there is NO registration during a week, the datediff function do not show the week

Total Registrations Week
2 6
5 5


4 3
4 2
1 1

I want to show that is if there is no registration on week 4 it will still show week 4, but with 0.

[ajetrumpet]

try preceeding the date function with either the NZ function or the IIF() function.

[William McKinley]

I had this same issue. I used the NZ() function and it worked great. Try doing NZ([Registrations Field],0)