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
