El wrote:
I have 5 different fields setup on my report to be =Count([field name
1]), etc. How do I go about adding the 5 counts together to get one
total? I do not want the data that are in my fields for this report.
I just need an overall count of how many there are in all 5 fields
combined. Any suggestions would be great. Thanks!
I don't understand as Count([FieldName1]) will always equal the Count() of
any other field... Count() gives you a count of records???
To add fields...
Give each textbox a name and then create another text box in the same
section that adds these together
eg.
= [FieldName1Count] + [FieldName2Count] + ...
Or do it within the query. Create a column that adds the fields together.
Because it is in the query you can then use it on your report and sum() it.
eg.
In query...
LineTotal: [FieldName1] + [FieldName2] + ...
On report footer...
= Sum([LineTotal])
--
regards,
Br@dley