Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Multiple Descriptions

Discussion in 'Information Technology' started by Supe, Jul 28, 2006.

  1. Supe

    Supe
    Expand Collapse
    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?
     
  2. Loading...


  3. Al Camp

    Al Camp
    Expand Collapse
    Guest

    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.
    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions


    "Supe" <Supe@discussions.microsoft.com> wrote in message
    news:4F6C18A7-8B10-48F2-9D08-9113ED92D550@microsoft.com...
    >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?
     

Share This Page