I am trying to do an "update" and an "append new" in one query. IIRC it was you (Gustav) who told me how to do that ages ago. IOW, if there are new records, append to the destination table, otherwise just update existing records. TIA -- John W. Colby