Print discrepency...

[Naveed]

Ok can anyone explain...

created a rport based on a query that totals up the costs
of maintenance ... the report can run over several pages..

i used NZ to add up after each row is printed... the final
total amounts to 20 000. when i print the report it shows
on the printout as 21 000.

i have checked the query and rechecked all of the fields
and values..

can anyone explain or offer a possible solution..

thank you.

 

[Marshall Barton]

created a rport based on a query that totals up the costs
of maintenance ... the report can run over several pages..

i used NZ to add up after each row is printed... the final
total amounts to 20 000. when i print the report it shows
on the printout as 21 000.

i have checked the query and rechecked all of the fields
and values..

can anyone explain or offer a possible solution.

What do you mean by "add up each row"?

If you're using code in an event procedure to accumulate a
total, then you should expect to get some of the values to
be added in more then once. It just plain impossible to
reliably calculate a total across multiple records. If
you'd explain where the values for the total are coming from
and what kind of total you need, maybe someone can come up
with another approach.

 

[Duane Hookom]

How are you creating the total? Is there a reason for not using:
=Sum([YourField])