Multiple descriptions for same part number

R

rapid1

I have a db with part numbers and descriptions for multiple store locations.
In theory, all locations have the same description for any given part number.
In reality, there are some part numbers with descriptions that differ from
location to location. I need a way to filter for only the part numbers that
have multiple descriptions and return to the query result the part number and
all descriptions for that part number.

TIA!
 
K

KARL DEWEY

Two queries.
Totals query with part number field twice. Group By on first and Count on
second. Criteria >1 on count.
Second query table with part number joined to totals query part number.
 
Top