A problem with counting the number of items after filtering records in reports.

S

Sam Hung

Hi All,

This time I found troubles in counting the number of
items "=Count([items])" or summing up the total amount "Sum
([cal_items])" in the report. Well, I had done filtering
in forms and reports. I guess it is the main point that
drives the problems in counting total. Am I right?

If so, what the command should be as I mentioned above?

Please help.
Thanks,
Sam.
 
J

Jeff Boyce

Sam

What are you trying to accomplish? You've described some of the "how", but
I'm not clear on the "what"...

More info, please...

Jeff Boyce
<Access MVP>
 
M

Mercedes Howard

Hi Sam,
Did you go to Access Help? I went there and typed
in "How Do I Add Up a Column?" and I got a long list of
instructions. Try that and see if it helps.
Good Luck
 

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

A03 - count in report footer gives me #Error? 0
Count or sum unique records in a report's group footer in Access 2 2
Count total number of groups in report 4
Report counting yes/no 2
count() or =Abs(Sum(([Item] function 7
Sum in report 10
display a total value 4
Question with counting in reports 3

Top