Number of records displayed

  • Thread starter Thread starter Tom N.
  • Start date Start date
T

Tom N.

I have a report that displays records obtained from a
query. Is there a way to make the report count and
display the number of records that show up?
 
Tom said:
I have a report that displays records obtained from a
query. Is there a way to make the report count and
display the number of records that show up?
Click to expand...

Use a text box with the expression =Count(*) in the report
header or footer section.
 
What would be the variable name??

-----Original Message-----
Sure, create a text box on your report and simply
insert "=count([enter a variable name here]). make sure
the variable name you enter has data in every record such
as The primary key.
Hope this helps.
Fons
-----Original Message-----
I have a report that displays records obtained from a
query. Is there a way to make the report count and
display the number of records that show up?
.
Click to expand...
.
Click to expand...
 
You don't need a variable (actually a field name) if you use
* (asterisk), which has the special meaning of all records.
--
Marsh
MVP [MS Access]


What would be the variable name??

-----Original Message-----
Sure, create a text box on your report and simply
insert "=count([enter a variable name here]). make sure
the variable name you enter has data in every record
such as The primary key.
-----Original Message-----
I have a report that displays records obtained from a
query. Is there a way to make the report count and
display the number of records that show up?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top