how to display a count of "0" in report

[clickaccess]

Hi,

I have a report that through query counts the number of records in a table for display.

My problem is that if there are no records I am getting "#error". How can I display a "0", if there are no records?

in the text box this i what I have, =

.[count]

Thanks
Click

Email Service Free from Banner ads.

http://www.SacMail.com

 

[Xenos132]

Try this

=Nz(

.[count]),0

 

[clickaccess]

Thanks, I will try this out tomorrow at work.

Click

Email Service Free from Banner ads.

http://www.SacMail.com

 

[dhookom]

If there are no records in the report's record source,

=Nz([table].[count]),0

will not work. Even if the 0 was inside the ) it still would not work.

To count the records in a record source, try set the control source to:

=IIf(HasData,Count(*),0)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[clickaccess]

=IIf(HasData,Count(*),0) works!

thank you

Click

Email Service Free from Banner ads.

http://www.SacMail.com

 

[Lightningfast]

Thanks I was sure there would be a simple answer