Total sum for Records in a Report

[jdwm2310]

Hi,

I have a database used by 3 individuals.
In the report I created a subheader for those 3 individuals adding info. I can't seem to find a way to obtain seperate totals for those individuals.
For example:
Bob entered 5 records I would like to see underneath Bob's subreport that he has a total of 5 records.

could you please advise as how I can go about approaching this..thanks

 

[CosmoKramer]

In the report footer of your subreport, put a text box with something like the following in its control source:

=Count([YourFieldName])

 

[jdwm2310]

It worked, thanks!!!!!!!!!!!!!!

 

[wiginprov]

I tried it and I get #Error. Any suggestions?

 

[CosmoKramer]

Is the field name you substituted for [YourFieldName] spelled correctly?? This is the most common cause...

 

[wiginprov]

Yes. I should add that the report is reading a query, and filtering on records for a particular individual. The formula works if I am reading a full table, but not with this report from a query. ?

 

[CosmoKramer]

Is this the same scenario that jdwm2310 had? Make sure the field name you specify is the one from your subreport, not the query....

 

[wiginprov]

I was looking at that. I'm not sure I understand the situation. I do not have a subreport.

Am I correct that I need to add a field to my query? If so, what do I add and what criteria do I set?

Regrets,...newbie.

 

[CosmoKramer]

No, you don't have to add a field to your query. If you want to for example count detail records, define a group footer, or if your report will be filtered for an individual, use the report footer. Put your calculated text box in either the group footer, or in the report footer and you should be all set....

HTH

 

[wiginprov]

All set. It worked in the Report Footer.

MANY THANKS!