Sum non numeric

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to I sum the non-numeric fields. I do a count on the non-numeric field at
the footer level, now I want the total at the end of the report.

TIA
 
Steve,

If you mean you have a record count for each group in a group footer,
and now you want an overall count of records for the whole report, then
you don't need to "sum" the group counts, you can just put an unbound
textbox in the Report Footer with its Control Source set to =Count(*)

Apologies in advance if I have missed your meaning. If so, please post
back with more details, maybe with examples.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Blanks in Non Numeric Fields 1
Text Data to Numeric for Report 3
page totals 2
Summing a data field for the whole report 3
Can't figure out what I'm doing wrong with running sum 2
Report grouped totals not resetting. 2
Report Headers/Design 4
Sum of field in report 1

Back
Top