Exclude records in query

[Guest]

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

 

[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".

 

[Guest]

Jeff,

Many thanks, this is exactly what I needed.