Report Totals and Counts

M

mattmanp

I have a field set up to add up the total of a field of charge
"=Sum([TotCharges])" but when I open the report it just says #Error
The textbox is in the footer.

Also I would like to create a textbox that does a count of dates tha
aren't null.

Thanks for the help
Mat
 
M

Marshall Barton

mattmanp said:
I have a field set up to add up the total of a field of charges
"=Sum([TotCharges])" but when I open the report it just says #Error.
The textbox is in the footer.

Also I would like to create a textbox that does a count of dates that
aren't null.
Click to expand...


Your use of the word "field" is ambiguous, I can't tell
what you are trying to Sum. Of TotCharges is a **control**
on the report, then Sum can not operate on it. All the
aggregate functions only work with **fields** in the
report's record source table/query. You can Sum an
expression that only refers to **fields** such as
=Sum(Quantity * Price + Shipping)

Since the aggregate functions ignore Nulls, you can count
the number of non-Null date **fields** by just counting the
date field:
=Count(datefield)
 
M

mattmanp

The field TotCharges is part of my main table, every record has
number of charges and the total amount charged. I am trying to su
the total amount of charges post filter for each client as part of
report

I also have a sum(RecieveDate) and it is giving me an error too.
have no idea what I am doing wrong. Thanks for the help
 
Top