sum of columns by row

[douggy]

I need to add up the stock quantities by row so my resultant query adds up 49 and 41 (eg the first line of my example) and adds a column containing 90. Can you help?

prd_rcn | prc_stkqty(1)| prc_stkqty(2)

52 49 41
52 26 17
52 20 32

 

[SkipVought]

Hi,

Select prd_rcn, prc_stkqty(1), prc_stkqty(2), prc_stkqty+ prc_stkqty(2)

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

I think that would need the square brackets and the missing (1)

Select prd_rcn, [prc_stkqty(1)], [prc_stkqty(2)], [prc_stkqty(1)]+ [prc_stkqty(2)] as Qty1_2

Duane
Hook'D on Access
MS Access MVP