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.

Very simple. Leave your query alone. Craete a text box on your report footer. In its 'control source' property just type as below:

= count(*)

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

http://www.access-programmers.co.uk/ubb/frown.gif Can't believe how frustrating this is, for how simple it seems!

Did you create a text box in the footer ?
Also make the text box wide enough to accommodate all the digits of the number.



[This message has been edited by araskas (edited 03-26-2002).]

Yes, I made an unbound text box in the report footer. I went into properties and in the control source typed in

=Count(*)

The count should be maybe 25 records or so, and I made the text box about 1/3 of the width of the page, so that shouldn't be a problem.

When I run the report I get

#Error

where the count should be.


**Also, due to another suggestion, I tried typing =Count([Incident#]) in the control source property, but that gave the same results.

[This message has been edited by kbrooks (edited 03-26-2002).]