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

finding duplicates with two fields....

P: n/a
Hi all,

i am having a problems with a SQL select query. I have to find all the
records in a ONE table where TWO fields, field1 and field2 for
example, are duplicated.

eg

field1 field2
a b
a c
c d
a b

the desire result would return records 1 and 4 (a b)

Any help would be appreciated,

Regards, Alan
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
1. Create a query.

2. Drag 2 copies of the table into the design grid.
Access will alias the 2nd one as "...._1".

3. Drag Field1 from TableA onto Field1 in TableA_1.
Drag Field2 from TableA onto Field1 in TableA_2.
You now have two join lines.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AlanAylett" <al*********@breyservices.co.uk> wrote in message
news:69**************************@posting.google.c om...
Hi all,

i am having a problems with a SQL select query. I have to find all the
records in a ONE table where TWO fields, field1 and field2 for
example, are duplicated.

eg

field1 field2
a b
a c
c d
a b

the desire result would return records 1 and 4 (a b)

Any help would be appreciated,

Regards, Alan

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.