SUM in Select Stmnt: Syntax Error

[Former Member]

Keeps saying field (LABST)not there. It is. and I can select alone but cannot do sum...why? Thanks.

select sum(LABST) from MARD into (tlabst)

where MATNR = tlocations-MATERIAL

and WERKS = tlocations-PLANT

and LFGJA = year

and LABST > 0.

endselect.

[Former Member]

Add spaces:

select sum( LABST ) from MARD into (tlabst)

Rob