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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple descriptions for same part number 1
Embed the same Excel multiple times 0
Unmatched in same(1) table 5
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Document Merge Formatting Issue 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Lower-Case Characters 2
Unmatached in 1 Table 1

Top