Exclude records in query

S

Steve Whitnear

Hi,

I have a query for forecasting component requirements from bill of materials
and sales forecast tables. I want to do a risk assessment on different
groups of top level part numbers in the sales forecast and see the effect in
the component forecast per month. I can create a new query and link the
forecast query with a table of top level parts to see the component forecast
for this group of top level part numbers but how can I create a query that
excludes component forecast records based on a list of top level parts?

Thanks
Steve
 
J

Jeff Boyce

Steve

If you can create a query that returns top level parts, it would seem you'd
want to create a new query that says "find all from my first query that are
not in my top-level parts query".

If so, you can do this by:
having a common field (?ID) the two queries share,
joining the first to the second ("top-level") query,
changing the join to be (all of first query and any of second that match),
selecting the "joined to" field from the second, and setting a criterion of "Is Null"
selecting from your first query all fields you need.
Click to expand...

Or have I misunderstood what you're trying to see?
 
Top