Find matches

[e]

how do capture - matching data from one field to another field in a query?

 

[ghetto_banjo]

you just link those fields in the query setup. Drag a line form one
field in one table to another field in the another table.

 

[John Spencer (MVP)]

In the same table, just enter the tablename and fieldname in the criteria.

Field: FieldA
Table: YourTable
Criteria: =[YourTable].[FieldB]

That catches all matches EXCEPT when both fields are null. If you have that
case you would need to add additional criteria to test is both fields were
null on a separate line in the query criteria


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County