 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / April 2006Counts
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 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])  Signatureregards, Br@dley |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.