zero values

[kato68]

I want my report to show zero values for all values there is no data for. Problem is that when my queries return no value there is no row at all, so i have no null values to work with.

(this problem is in the summary fields, where there is no data for the month the report is generated for)

 

[mark curtis]

If there is no data to return then how can you show any data?

If you have a query that returns some static data such as employee name, dob and then you want to show something like employee scores, which could be for some employees or not then something like the following in the query could work?

iif(isnull([employeescore]),"0",[employeescore)

 

[Pat Hartman]

If the problem is caused by a join, you can change the join type from inner to left. That may solve your missing records problem.

 

[kato68]

The queries I am using count the number of permits in a particular instance and sum the permit fees. I have 3 queries for each instance. The month, the YTD and the previous YTD. If there is no instances for that particular month, etc. No rows are returned. When that happens I want it to print zeros into the report instead of a blank space.

I tried the isnull fuction exactly like you wrote it, but that didnt work.

I was thinking maybe the HasData fucntion but I still havnet gotten that to work yet. I am still pretty new at access.

-Kate