Calculation based on count of records in a query

[brittb]

Hi,



I'm trying to create report that will have calculated values based on the number of returned records for a query. The query returns records based on the date, so the number of records returned will change day to day. The calculations in the report should reflect the fluctuating number of records in the query. Hopefully that makes sense.

So in the report, I have a text box with the Control Source:

=13.2+4.4*Count([QueryName].[FieldName])

Access seems to like the context okay (no error messages in Design View), but I get an error when I go to Report View. Is there some other way I should be telling it to count the number of records in the query? Is there something wrong with the syntax?

Thanks!

[pbaldy]

Try

=13.2+4.4*DCount("*", "[QueryName]")

[brittb]

Thanks! That fixed it.

[pbaldy]

No problem, and welcome to the site by the way!