I would like to update chks in the register by appending 2 suffix, 1 for Mgmt Dept and the other for RE dept, do i have to use 2 diff update queries? or can i do something like a batch?

PARAMETERS LstAllocDate DateTime, LstMgmtCKNum Text ( 255 ),
LstMgmtCKNum Text ( 255 );

UPDATE tblFedexChecks cks
SET cks.CheckNum = Trim([checkNum]) & "-RE"
WHERE (((cks.CheckNum)>[LstMgmtCKNum]) ;

UPDATE tblFedexChecks cks
SET cks.CheckNum = Trim([checkNum]) & "-RE"
WHERE (((cks.CheckNum)>[LstRECKNum]) ;