Generating A Count In A Report

[McArthurGDM]

Hi,



I have a Query that is not associated with a particular report that I am running. However, all I want to do on the report is display the count of that particular query. I can not seem to do this without receiving an error message.

Does anyone know how to do this?


My second option is to create a subreport that has this query built into it. The count shows up in this subreport. However, the field in which I am displaying the count in gets generated however many records there are in that query, when I just want it to show up once.

Any help is appreciated.

[June7]

Put that field in subreport header or footer section. If you don't want detail records then don't put controls in detail section or set it as not visible.

Or use domain aggregate function expression in textbox on primary report and eliminate subreport.

=DLookup("fieldname", "table or query name")

or

=DCount("*", "table or query name")

[McArthurGDM]

Thank you, that DCount function worked. I didn't think to use that. I think the Count function itself must be dependent on a reports underlying table/query.

[June7]

That is correct.