Join / Iff Question

[COMUBO]

We have two tables, Meter Inventory and Location Table. We want to produce a
listing of meters based on a group number within the inventory table. This
is working correctly using "Criteria" within the query and matching to the
location table for addresses. What we want to do if the location code within
inventory is "WH", we do not want to list the address fields from the
location table, even if the address exists for the meter. Can we change our
join to the location table to add more criteria or "IFF" condition? We are
new users and need guidance.

 

[Allen Browne]

Simple solution is to first make a query that returns only the locations you
want, i.e. exclude the "WH" records.

Then create a new query that joins your main table with that query.