CRITERIA PROBLEM STATEMENT

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

Guest

i have a table with the following fields: code, deccription, vehicle code and price.

the vehicle field is a lookup field to another table containing vehicle code and description fields.

i have set my lookup field 's limit to list option to <no>, as it does not contain values only from the lookup table.

i want to create a query that displays all the records whose vehicle field contains a value other than the ones listed in the lookup table.

can i do that?

pls help me!
 
Number one, we recommend that you not use the Lookup field option in your
table. It will cause immeasurable confusion to you.

Number two, without knowing the details of your table setup, the query
should generically be something like this:

SELECT TableOne.*
FROM TableOne
LEFT JOIN TableTwo
ON TableOne.VehicleCode = TableTwo.VehicleCode
WHERE TableTwo.VehicleCode Is Null;

TableOne is the four-field table, and TableTwo is the two-field table.

--

Ken Snell
<MS ACCESS MVP>

angie said:
i have a table with the following fields: code, deccription, vehicle code and price.

the vehicle field is a lookup field to another table containing vehicle code and description fields.

i have set my lookup field 's limit to list option to <no>, as it does not
Click to expand...
contain values only from the lookup table.
i want to create a query that displays all the records whose vehicle field
Click to expand...
contains a value other than the ones listed in the lookup table.
 
Back
Top