>Instead of running a Select SPT statement to check for the existence of a record, how can I use the Update statement to do both? If record exists update it. if it dosen't do an insert.

With a single UPDATE is not possible.

You can use this in not multiuser env.

UPDATE ..... WHERE pk=....
IF EMPTY(_TALLY)
  INSERT ....
ENDIF