=sum()

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi,

I have created a report that gives me a print out of LastNames how can I get
the report to total up how many lastnames there is in the report. I have
tried =sum() in the report footer. Should I have something else inside the
brackets like =sum(lastname)? Please help thank you in anticipation.

Dave
 
Dave,
In an unbound control in the Report Footer:
To get a count of 'All' the records:
=Count(*)

To get a count of just the entries in the [LastName] field:
=Count([LastName])
 
Thanks Fred I was just about to report to the newsgroup that I had found
that answer thro' trial and error. I now have a new problem around the same
subject as follows. Now that I have enterered =count([Last Name]) i get the
value I require however i now get a comment box as follows:

Enter Parameter Value
Last Name

OK Cancel

Question....how do I get it to calculate without haveing to ener Last Name
in this box?
 
Dave,
My guess is you have either miss-spelled the field name, or you do not have
a field named 'Last Name'.
Check the spelling and the space.
"Last Name" is not the same as "LastName".
 
Thanks Fred still havent sorted it but I did try =count(*) and that seems to
work fine.

Fredg said:
Dave,
My guess is you have either miss-spelled the field name, or you do not have
a field named 'Last Name'.
Check the spelling and the space.
"Last Name" is not the same as "LastName".


--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Dave said:
Thanks Fred I was just about to report to the newsgroup that I had found
that answer thro' trial and error. I now have a new problem around the same
subject as follows. Now that I have enterered =count([Last Name]) i get the
value I require however i now get a comment box as follows:

Enter Parameter Value
Last Name

OK Cancel

Question....how do I get it to calculate without haveing to ener Last Name
in this box?
Click to expand...
Click to expand...
 
Back
Top