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