Rpt that shows Count Query returnes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Count Q that I would like to show the Count on a report.
The Report is not feed by the Query.
Can I do this?

Would be a great help if I can. Thanks
 
I have a Count Q that I would like to show the Count on a report.
The Report is not feed by the Query.
Can I do this?

Would be a great help if I can. Thanks
Click to expand...

Is that the only value returned by the query?
=DLookUp("[FieldName]","QueryName")
 
KAnoe said:
I have a Count Q that I would like to show the Count on a report.
The Report is not feed by the Query.
Click to expand...


A text box with the expression:
=DLookup("countfield", "countquery")
would do that, but why not just use the Count function, or
if that won't do it in your situation, use a text box with
its RunningSum property set to Over All.
 
Back
Top