Find matches

  • Thread starter Thread starter e
  • Start date Start date
E

e

how do capture - matching data from one field to another field in a query?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Senior moment on capturing all records from joined query 2
Compare fields against each other in a table 3
Query Joins 2
number format display without decimal 1
Excel Highlighting duplicates 0
When Change In Data Add Record in Access 9
Querying all records; include mismatches 1
Matching data from different columns 6

Back
Top