Dawn,
Certainly much more elegant than the hack I was working on. Thank you. It works beautifully. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Hast Sent: Tuesday, November 25, 2008 12:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Simple Syntax Question Damon, You don't need the group by. Try this syntax: SET VAR vThisCheckAdded CURRENCY SELECT SUM(prhdr.ded14 + prhdr.ded15) INTO vThisCheckAdded FROM prhdr, employee401k WHERE prhdr.eid = employee401k.eid -------------- Original message from "Gray, Damon" <[EMAIL PROTECTED]>: -------------- I'm getting a syntax error on the below. I need the CURRENCY value of DED14 and DED15 to be summed and then assigned to vThisCheckAdded. I can't seem to wrap my mind around how to get that done. I've trued multiple permutations of the query below with no luck. It's likely obvious and staring me in the face, but... SET VARIABLE vThisCheckAdded = Select Sum(PRHDR.DED14 + PRHDR.DED15) >From PRHDR, EMPLOYEE401K Where PRHDR.EID = EMPLOYEE401K.EID Group By EMPLOYEE401K.EID Damon J. Gray Anvil Corporation Business Services (360) 937-0770
