Hi Ed..

Thanks,

Actually I did sort of do the first one...

first part of the query updates the flags marked 'Processed' to 'Completed'

second part updates "null" to "Processed"

then data is written to report selecting processed records...

Since the report is scheduled daily

the following day it will mark those records 'Processed' to 'Completed'

if for some reason it fails the records will be marked "Processed" still sending then to the report

That was my whole thing for step2 to mark them as processed...