Query if all locations are counted

[Ashabel]

I have a table that includes:

• Product SKU (text)

• Bin Location (text)

• Quantity (double) (defaults to NULL as a quantity can have be valid with a zero entered.)

A product may exist in one or more bin locations and be listed more than once as a result.

I want this query to return a list of products that have had all their quantities entered. Ultimately I also need the sum of quantities, but once the first part gets completed I can figure out the second.

[twinnyfo]

Ashabel,

This is a very basic question about queries. What have you tried so far?

[Ashabel]

Okay, so I solved this by creating a trio of queries.

#1 - Identify all parts that have a null quantity.
#2 - Total the non-null quantities for all parts.
#3 - Join the 2 tables including all results from #2 where the joined part in #1 "is null"

This creates my "exclusionary query" that I'm after.

[twinnyfo]

You should be able to do this with one query. Please post your SQL statements and we can try to provide a better solution.