all fields not showing in umatched query wizard dialog box

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

Guest

All of the fields are not showing for one of the tables when I try to perform
an unmatched query. It is important because the field I want to match on is
not showing up in the dialog box.
 
All of the fields are not showing for one of the tables when I try to perform
an unmatched query. It is important because the field I want to match on is
not showing up in the dialog box.
Click to expand...

Roll your own unmatched query; the wizards aren't all that bright!

Create a Query joining the two tables on the matching field. Select
the Join line; choose option 2 - "show all records in <one table> and
matching records in <second table>". Select only the match field from
the second table and put a criterion of

IS NULL

on it; and select any desired fields from the first table. You'll see
only those recores in <one table> which do not have a match in <second
table>.

John W. Vinson[MVP]
 
Back
Top