HELP! Need to count records on a report

kbrooks

Still learning
Local time
Today, 04:57
Joined
May 15, 2001
Messages
202
I have a database set up tracking work accidents, etc. They have had me set up several reports showing various information, which I have pulling from various queries.

Now they are wanting a COUNT of all records on each reports. Doesn't seem that difficult but I can't figure out quite how to do it. I put =Count(*) in the report footer but it just gives me an error. I have a manual that shows how to set up a count query, but it shows no detail. I want my detailed report, only with a count at the end.

One thing all records have in common is an incident#, if that helps.
 
Kbrooks,

In an unbound text box in the report footer try:

=Count([Incident#])

HTH,

Lyn
 
I get "Error" in that area when I enter that.

frown.gif
Can't believe how frustrating this is, for how simple it seems!
 
Try placing an unbound textbox in the detail section of your report. Give it a Data Control Source of =1
Set running sum Over Group
Give the text box the name "LineCount"
Set the text box visible property to "No" if you do not want to show the line numbers in your report.

In the report footer section, create another unbound text box. Set its value to:
=([LineCount]).

Let me know of this works for you.
 

Users who are viewing this thread

Back
Top Bottom