Replacing error when count = nil.

  • Thread starter Thread starter Baz.
  • Start date Start date
B

Baz.

I have a report that is printed each day and counts the
number of orders each day. On some days there will be no
orders so the count should read nil. But at the moment
it shows #error# instead of nil. Is there anyway I can
change this. I think I am currently using =Count([Qty]).
 
Reports are generally based on recordsets, either tables or queries
(including SQL statements). Somewhere in your report's underlying source
(I'd recommend using a query), you need to handle the situation when there
is nothing to count (i.e., a Null).

Take a look at the Nz() function in Access HELP.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top