Adding Dates

[ChrisF]

I have a report full of dates that items have been issued to members of staff. I need a calulation that can tell me how many items have been issued. I have tried:

=Count([EarPlugs])
and
=Sum([EarPlugs])

but i just get #Error

Any ideas on what to do!?

 

[daveUK]

Hi Chris

=Count([Name of Field]) should work. Are you sure [EarPlugs] is the EXACT name of the field? i.e. It's not [Ear_Plugs].

Try it with another field on the report, as long as there is a value for each line of the report, it doesn't matter which field you use.

Dave

 

[Rich]

Where on the Report are you using these calculations?

 

[ChrisF]

i was using it in the Footer of the document, but not u said that i have tried it in the mian body of the document and it works. Yet again something so simple! Doh!!!

Cheers Peeps