Sum error in report

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

Guest

This looks like a fairly common problem, but in this case I am puzzled
because there are no Null values involved - the common factor I can see in
(many) other requests for help on this. If I change the underlying query to
do the sum for me, and I then run the query, it produces the expected results
and sum. I have a field in a report called PostageCost. If I put a
calculated text field at the end of the report "=Sum([PostageCost])", the
dreaded #Error appears.
 
1. If the sum field on the page footer, move it to the report footer

2. The Sum should include the name of the field in the table, and not the
name of the field in the report, incase the names are different
 
Thanks, Ofer - I will give your first suggestion a try later today, and let
you know how I got on. The second suggestion is good, but not applicable in
this case.

Ofer said:
1. If the sum field on the page footer, move it to the report footer

2. The Sum should include the name of the field in the table, and not the
name of the field in the report, incase the names are different

--
I hope that helped
Good luck


JMCS said:
This looks like a fairly common problem, but in this case I am puzzled
because there are no Null values involved - the common factor I can see in
(many) other requests for help on this. If I change the underlying query to
do the sum for me, and I then run the query, it produces the expected results
and sum. I have a field in a report called PostageCost. If I put a
calculated text field at the end of the report "=Sum([PostageCost])", the
dreaded #Error appears.
Click to expand...
Click to expand...
 
Ofer

Thanks - No 1 was spot on - silly mistake on my part, so thanks again for
your help.
Regards
JMCS

Ofer said:
1. If the sum field on the page footer, move it to the report footer

2. The Sum should include the name of the field in the table, and not the
name of the field in the report, incase the names are different

--
I hope that helped
Good luck


JMCS said:
This looks like a fairly common problem, but in this case I am puzzled
because there are no Null values involved - the common factor I can see in
(many) other requests for help on this. If I change the underlying query to
do the sum for me, and I then run the query, it produces the expected results
and sum. I have a field in a report called PostageCost. If I put a
calculated text field at the end of the report "=Sum([PostageCost])", the
dreaded #Error appears.
Click to expand...
Click to expand...
 
Back
Top