Multiple descriptions for same part number

  • Thread starter Thread starter rapid1
  • Start date Start date
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!
 
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.
 
Back
Top