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

Expand|Select|Wrap|Line Numbers

 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

Expand|Select|Wrap|Line Numbers

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. :)

How to get a reports of update query

re: How to get a reports of update query

re: How to get a reports of update query

re: How to get a reports of update query

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about