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

update record with data from another record in same table

P: 6
How do I update a field in a record based on the value of another field in another record - in the same table?

Specifically, I want to update the value in the AMOUNT field of record1 with the value of the AMOUNT field in record 2 when the value in the YEAR field of record 2 meets a certain criteria. In addition, the records also have to match on 2 other fields

Mar 26 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
Kindly post what you have done so far. Some sample data will also be great, together with your desired output.

-- CK
Mar 27 '08 #2

Post your reply

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