Number of records displayed

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?
 
M

Marshall Barton

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?

Use a text box with the expression =Count(*) in the report
header or footer section.
 
G

Guest

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?
.
.
 
M

Marshall Barton

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top