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

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

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]