calculating a sum

[verschup]

This is maybe a stupid question, but it's already kept me up several nights

I've got db with project leaders updating their savings each month:
January savings1 savings2 savings3
February savings1 savings2 savings3

If I want to make a sum (in my query) for savings1, savings2 and savings3, how do I do this?

Expr1: [savings1]+[savings2]+[savings3] won't work....

 

[RobW]

Expr1: Sum([Savings1]+[Savings2]+[Savings3])

Should do it i think

 

[dcx693]

Expr1: [savings1]+[savings2]+[savings3]+...etc...
is the easiest way to do it. Why doesn't it work for you? What happens when you try to do that?

Expr1: Sum([Savings1]+[Savings2]+[Savings3])
won't work in a query expression.

 

[Rich]

why do you have three separate fields for savings anyway?