Report Totals and Counts

  • Thread starter Thread starter mattmanp
  • Start date Start date
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
 
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)
 
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
 
mattmanp said:
The field TotCharges is part of my main table, every record has a
number of charges and the total amount charged. I am trying to sum
the total amount of charges post filter for each client as part of a
report.

I also have a sum(RecieveDate) and it is giving me an error too.
Click to expand...


Where are these total text boxes? If they're in the
report's Page header/footer, they won't work, they must be
in the Report header/footer.

The number of records with a non-Null date field needs to
use the expression
=Count([ReceiveDate])
 
Back
Top