Error while Adding two columns....

[konquistador]

Hi guys, Excuse my novice questions.
I have a query in which i did two things: defined a Column "Line Item Cost " as Sum ( using the dropdown in Design Grid of the query).
Then i calculated another field: Expr13 which is:
Expr 13: Sum([Line Item Cost]+ [Change Request Total Cost])

So, If Line Item Cost = 1363000 and Change Request Total Cost = -40000, then
Expr13 : 1363000-40000 = 1323000, but i am getting the values: 1283000(Somehow the value is getting doubled before addition)

Please look at the attached Document.
Please Help!

Thanks,
Kon

 

[Guus2005]

It doesn't make any sense. It is an odd problem. Can you post a Acc2003 version of the problem?

 

[neileg]

I'm not sure if this is the cause of your problem but using Sum in this formula is redundant. The formula should be

Expr 13: [Line Item Cost]+ [Change Request Total Cost]