Count Error Message

S

Sean

I'm using =Count(*) in a report footer to count the total number of records,
but I'm getting a #Error result. What's wrong?
 
D

Duane Hookom

Is the control actually in the Report Footer or the Page Footer?
Does the report return any records?
If the report is not returning any records and you want to display 0 then
use
=IIf([HasData], Count(*), 0)
 
Top