SQL Problem

[Guest]

I am having a problem writing a query - I have a number of fields shall we
say Fld1, Fld2, Fld3, Fld4. I need to show all fields where there are
duplicate values in Fld1 with Fld2 having a value of 'A' shall we say.
Can anyone help

TIA

Mark

 

[Guest]

If I understand your question, try:
SELECT Table1.[field 1], Table1.field2, Table1.field3, Table1.field4
FROM Table1
WHERE (((Table1.field2)=[Table1]![field 1]));