Access 2007 Query criteria

  • Thread starter Thread starter Janice
  • Start date Start date
J

Janice

I have one table that has some fields based on look up fields from other
tables. I want to display records related to these look up fields but I get
a data field mismatch message. Example Contacts table includes a look up
field from a Category table (one of the entries in the Category table is
"Corporate") I then do a query based on the Contacts table and under
Category I type Corporate. I get date type mismatch message HELP!
 
Does your query include the "other tables" that actually store the values
like "Corporate"? If not, add them. You should also make sure the data types
of the linked fields match.

Most of us veteran/mature programmers don't ever use lookup fields. However
there are even some immature veteran MVPs who continue to use them ;-)
 
Back
Top