Multiple Descriptions

[Guest]

I ran an append query to list all the UPC and descriptions for all the items
for a particular vendor. The Master table I am pulling this from is from
data that was input from serveral differerent location so one UPC may have
several different descriptions(12 pk vs. 12 pack for example) so when I run
the append query I get serveral lines for the same UPC. Want to have only
one line per UPC. Unique Value doesn't work because of the different
description names. Can I tell it to select the longest description or
something like that?

 

[Al Camp]

Supe,
So you're basically using a Totals Query to group on the UPCCode, but you get multiple
identical UPC codes due to the diffrence between the UPCDesc?
If so...
Create a calculated field
DescLength : Len(UPCDesc)
and sort on DescLength Ascending. Now make that a Last grouping.
That should collapse all the same identical UPCs to one record, with the longest
UPCDesc.

Didn't test this, but I think it should fly.