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

delete when duplicate

P: n/a
Can someone tell me how I would delete all rows but one when both records
(in a two column setup) are duplicates? For example:

NAME | AGE

BOB | 23
BOB | 23
BOB | 23
BOB | 25
BOB | 25
JIM | 32
JIM | 32
JIM | 20
JIM | 20
JIM | 20

Should end up simply as

BOB | 23
BOB | 25
JIM | 32
JIM | 20

Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Fri, 03 Oct 2003 19:44:17 GMT in comp.databases.ms-access,
ca****@unlv.edu (Carl) wrote:
Can someone tell me how I would delete all rows but one when both records
(in a two column setup) are duplicates? For example:

NAME | AGE

BOB | 23
BOB | 23
BOB | 23
BOB | 25
BOB | 25
JIM | 32
JIM | 32
JIM | 20
JIM | 20
JIM | 20

Should end up simply as

BOB | 23
BOB | 25
JIM | 32
JIM | 20


http://www.trevor.easynet.co.uk/AccF...es.htm#DelDupe

You will of course need another two strings.

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.