=IIf([Report].[HasData];Count([COL_NAME]);0)

[Onno]

Hi,
I'm trying to understand a bit of MS Access magic.

I have a report where number of records in the report is crucial information. For this reason I want to display a count on the report header page. I have one report where I succeeded in doing so using a text box with the following data source property
=IIf([Report].[HasData];Count([COL_NAME]);0)

I have another report that was copied from the first that uses the exact same query. The text box now always displays #Error as the value. I have tried several variations on the data source property but the result is always the same: #Error. I have tried for example
=IIf([Report].[HasData];Count([COL_NAME]);0)
=IIf([Report].[HasData];Count(*);0)
=IIf([Report].[HasData];Count("*");0)

Is there a way to debug this problem? I have spend countless hours trying to figure out why it doesn't work in the second report but really got step further to understand the mechanisme behind counting records in MS access reports.

Is there a debugger of some sorts where we can step into the count-function to see why this does not work.

Thanks and Regards,
Onno

[Rawb]

I don't know if this is where your problem is or not, but those semicolons (;) should be commas (,).

Assuming that doesn't fix the problem, does the Report actually contain any data? (If that does fix the problem, you can ignore this question and just mark the thread solved ).

[NoellaG]

Hi,

if you are using European settings, only in the VBA window function arguments are separated by ",". In the control source property of form/report controls and in calculated queries European settings demand a semi-colon ";" to divide the arguments of a function.

To count the number of records in a report I never had trouble using the simple :

=Count(*)

greetings
NG

[Rawb]

Bah, silly Europeans. Always trying to do things the hard way, like using the metric system!

[weekend00]

I don't think Onno is using European setting, because tried

=IIf([Report].[HasData];Count([COL_NAME]);0)
=IIf([Report].[HasData];Count(*);0)
=IIf([Report].[HasData];Count("*");0)

and fail.

I did try =IIf([Report].[HasData],Count(*),0) and it worked.

[evander]

How interesting.

It's my first time to know about "European" settings in Access.
Great thing to know.

[Onno]

As it turns out I can only use count in the report header or report footer. So my bad, I copied it to the wrong location.