By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

How to get a reports of update query

atksamy
P: 91
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
  1. sqltext = update table employees set bonus = 0 where salary > 50000 
  2.  
  3. 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
Dec 2 '08 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
Why not something like
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM employees WHERE salary>50000
  2.  
?
Dec 2 '08 #2

atksamy
P: 91
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.
Dec 3 '08 #3

FishVal
Expert 2.5K+
P: 2,653
So create report before update. :)
Dec 3 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.