SUM of multiple columns

[lynaskin]

I have a db of products that has the qty on hand in each of 4 warehouses.

QTY1, QTY2, QTY3, QTY4
2,17,9,47

I can't seem to figure out a simple query in access 2003 that will add those qty on hand number together to give me a total quantity on hand.

Thanks!
Lyn

[DonRayner]

I have a db of products that has the qty on hand in each of 4 warehouses.

QTY1, QTY2, QTY3, QTY4
2,17,9,47

I can't seem to figure out a simple query in access 2003 that will add those qty on hand number together to give me a total quantity on hand.

Thanks!
Lyn

Just create a fifth field in your query to add up the previous four fields.

Total:[qty1]+[qty2]+[qty3]+[qty4]

[lynaskin]

Wow. I feel really stupid. . . .

Thank You!!!!

Lyn

[DonRayner]

No worry, we all have days like that ;)