sum not tally

  • Thread starter Thread starter zyus
  • Start date Start date
Z

zyus

I used this "=Sum([NET_BAL])" in text box in my report grouping header to
calculate total amount of net_bal.

Problem is when i extracted raw data in my table based on the particular
group the total figure is not tally with the one that i have in my report.
The rest of the group are ok in my report.

What could gone wrong

TQ
 
I used this "=Sum([NET_BAL])" in text box in my report grouping header to
calculate total amount of net_bal.

Problem is when i extracted raw data in my table based on the particular
group the total figure is not tally with the one that i have in my report.
The rest of the group are ok in my report.

What could gone wrong

TQ
Click to expand...

The data is not what you think it is, or the expression is on the wrong place,
or there is some other error.

It's impossible to be more specific with an answer unless you're more specific
with the question! What's the Recordsource for the report? What are its
Sorting and Grouping properties? What is the nature of the "not tally"? How
did you extract the data from the table, and in what way did it disagree?
 
The recordsource is from a queryAB...combination of tbl A and tbl B. The
net_bal are one of the field in tbl A. Another field Product is also in tbl A.

In my report i sort & group by Product and sum up net_bal. I put my
expression in text box in product header.

I've managed to produce report as follow
Product Net_bal
A 1000
B 5000
C 1500

For comparison & verification i run a select query in tbl A based on the
grouping above and resulted amount for product B is not tally with my report
(say 4500) but it's fine with A & C.

I've also extracted the data and sum it up in excel format and the result
are also the same with my select query in tbl A.

I hope my explaination suffice.




John W. Vinson said:
I used this "=Sum([NET_BAL])" in text box in my report grouping header to
calculate total amount of net_bal.

Problem is when i extracted raw data in my table based on the particular
group the total figure is not tally with the one that i have in my report.
The rest of the group are ok in my report.

What could gone wrong

TQ
Click to expand...

The data is not what you think it is, or the expression is on the wrong place,
or there is some other error.

It's impossible to be more specific with an answer unless you're more specific
with the question! What's the Recordsource for the report? What are its
Sorting and Grouping properties? What is the nature of the "not tally"? How
did you extract the data from the table, and in what way did it disagree?
Click to expand...
 
Back
Top