Count/Total Rows

[fraser_lindsay]

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?

 

[Hayley Baxter]

Try this

=Count([Location])

Field names need surrounding square brackets.

Hay

 

[fraser_lindsay]

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.

 

[Hayley Baxter]

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

 

[fraser_lindsay]

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?

 

[Hayley Baxter]

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

 

[fraser_lindsay]

There you go! Perfect.

I knew it had to be my Access ineptitude somewhere.

Thanks very much for your help.

 

[roborro]

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