G Guest Dec 27, 2004 #1 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?
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 Dec 28, 2004 #2 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)
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)
