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?