"cyder" wrote
I want to create a <query> that will detect
whether I have the same value in
say field 3 and field 4.
In the Query Builder, choose your Table as the data source, and pull down
into the grid the fields of interest to you (likely the unique id fields of
the record will be important), and at least one of the two fields that
should be equal, then in the Criteria line under that field that should be
equal, enter an equal sign and the name of the other field to be tested for
equality.
In its simplest form, with the table names and excess parentheses removed,
its SQL is going to look something like this:
SELECT RecordID, Field3, Field4
FROM tblSomeTable
WHERE [Field4])=[Field3];
Larry Linson
Microsoft Access MVP