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

Help! Update Records with same values Query

P: 39
Hi

I would like a Query that Updates a field to indicate that records have a duplicate entry( records with same values).

My table is .....


Code........Process..........Quantity

56................4................100
56................4................100
56................4.................200
56................4.................300
56...............4.................300

So i basically want a query that updates a field to mark that records have same values. eg.


Code............Process............Quantity....... .Same

56....................4.....................100... ............Yes
56....................4.....................100... ............Yes
56....................4.....................200... ............No
56....................4.....................300... ............Yes
56....................4.....................300... ............Yes

Anyway of doing this? I was thinking a Group BY Query and An Update Query but cant seem to do it as usual!!

hope someone can help!

Thanks
Feb 10 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 374
is there some reason that you want to mark them as duplicate? are you trying to get them to doing something else with the value that you are setting?
Feb 10 '08 #2

P: 39
is there some reason that you want to mark them as duplicate? are you trying to get them to doing something else with the value that you are setting?
Yes. Once they are marked I want to deal with them seperately. So I will process the marked ones first and then process the ones that arent marked second.
Feb 10 '08 #3

Post your reply

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