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

how to update a repeated record

P: n/a
Hi guys,

just really want to know if someone can help me with a query.
I have the following table

[item code] [product name] [entered
date] [obsolete]
1 apple
01/01/2007 False
2 pear
01/01/2007 False
3 apple
31/12/2007 False

I want to use a update query to make it so the oldest individual
record's obsolete field become true. So it would look like the
following.:

[item code] [product name] [entered
date] [obsolete]
1 apple
01/01/2007 True
2 pear
01/01/2007 False
3 apple
31/12/2007 False
Thanks,

Tom
Dec 17 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.