Help! Update Records with same values Query

[JC2710]

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........Pro cess..........Q uantity

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....... ..............1 00............. ..Yes
56............. .......4....... ..............1 00............. ..Yes
56............. .......4....... ..............2 00............. ..No
56............. .......4....... ..............3 00............. ..Yes
56............. .......4....... ..............3 00............. ..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

[PianoMan64]

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?

[JC2710]

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.