I am still trying to get a total count of the number of rows in a report. The report lists employees as defined by my query.

I wnat the report to tell me how many rows i.e. entries there are for that report/criteria.

I have put this in the footer, in a text box:

=Count(Location)

I just chose one of the fields along the row as it shouldn't matter, I only want the total number of rows for that report.

However, all I get is 'Err' on the box.

I have tried searching this forum but suggetsions were what I have already done. What have I done wrong?

Try this

=Count([Location])

Field names need surrounding square brackets.

Hay

Hi Hayley,

Tried that, but it doesn't like that either. Still get the same error for some reason.

I seem to spend all day trying syntax in queries and reports that should work, but never do. Maybe it's just my rubbish Access skills.

If the query is pulling back only the criteria you want to count for your report then you should be able to use count(*) and this will count everything in your report.

Just noticed you are in Falkirk...not too far from me!

Hay

I am indeed, but I'm from the Kingdom of Fife, a Kirkcaldy Lad.

That didn't work. See what I mean, simple things just don't seem to work for me.

Here's a run down:

Report based on query.
Query reports all employees (name, payroll no. etc based on a criteria)
Report shows all information as it should
I put a text box in the report footer
in the text box I try '=Count([Field Name]) - Result is '#Error'
Then I try '=Count(*) - Result is '#Error'

I must have done something worng somewhere, but I can't see where.

All I really want is a total number of rows at the end of the report and I'll be happy.

Thanks for your help, any other suggestions?

Are you perhaps entering this in the page footer rather than the report footer? That's the only thing I can see that can be incorrect as your syntax is correct.

Hay

There you go! Perfect.

I knew it had to be my Access ineptitude somewhere.

Thanks very much for your help.

I was wondering if there is a way to get a count of different items in a report. I liked the ability to count all rolls in my report but can I break it down further? Example I have a report the list all stereo equipment that is for repair. I need to break it down to a list of equipment that has been repaired, not yet repaired, and equipment that has been shipped out. They need it in all one report.


How do I get beyond this?

=Count ([Items])

The field [Items] is the main field; the [description of failure] is the field I would like to get a count from:

Types of [description of failure]:

UNSALVAGEABLE
If it’s Blank then its not being repaired that the moment
Else 'something is entered' which means it has been repaired


Thank you

Roborro

Either sort the report by those categories so you can total them or create a separate report that justproduces the recap and insert it as a subreport. Base the subreport on a totals query.

Select RepairStatus, Count(*) as StatusCount
From YourTable;