Have Count() Return Zero

[Guest_imported]

In my query I am caluculating Age, then using Count() to get the number of people between a certain age range. If there are not people between the age range it does not return anything. Fine, however I attached the query to a report and on the report it shows up as an #error. Can I get it to display as a Zero? Help Please. I am a new at this.

 

[mscraig]

In your report in the object (ex. textbox) try something like:
=iif(Count() is null,0,Count())
Some variation on this idea should solve your problem.

 

[mscraig]

In your report in the object (ex. textbox) try something like:
=iif(Count() is null,0,Count())
Some variation on this idea should solve your problem.

 

[Nilgni]

There is a function called NZ that will return a zero if there is not value. It may work for your situation..
EXAMPLE: =NZ([myfieldname]) Hope it helped