How to get a reports of update query

[atksamy]

hi,

Is it possibel to get a report of the records that are updated using a update query.
I mean without using recordset. suppose

sqltext = update table employees set bonus = 0 where salary > 50000 

DoCmd.RunSQL sqltext

now after theis query runs is it possible to get the name of the employees for whom this update query was performed.
i would like to get the updated records in a excel file.

Thanks

[FishVal]

Why not something like

SELECT * FROM employees WHERE salary>50000

?

[atksamy]

Hmm thanks for the reply but in that case if there are records with bonus = 0 before the updation they would also be listed which I dont want.

[FishVal]

So create report before update. :)