SQL Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
If I understand your question, try:
SELECT Table1.[field 1], Table1.field2, Table1.field3, Table1.field4
FROM Table1
WHERE (((Table1.field2)=[Table1]![field 1]));
 
Back
Top