Welcome to SPN

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

Sign Up Now!

help! query for unique and highest value

Discussion in 'Information Technology' started by I need help!, Jul 28, 2006.

  1. I need help!

    I need help!
    Expand Collapse
    Guest

    Help! I have a spreadsheet with 2 columns:
    (1) # (representing/identifying individual people) and
    (2) # (representing sales)

    I need to query to show only the highest sale for each person.

    I know there has to be an easy way to do this.
    (If I filter in Excel for unique, I will still get every row).
    (Not sure how to use the topvalues and uniquevalues properties).
    I appreciate any and all suggestions! Thanks!!!
     
  2. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

    This group is for Access, perhaps you'd be better served in an Excel
    newsgroup...

    --
    hth,
    SusanV

    "I need help!" <I need help!@discussions.microsoft.com> wrote in message
    news:FD539B71-0AE5-49B6-B20E-CBC02505B86D@microsoft.com...
    > Help! I have a spreadsheet with 2 columns:
    > (1) # (representing/identifying individual people) and
    > (2) # (representing sales)
    >
    > I need to query to show only the highest sale for each person.
    >
    > I know there has to be an easy way to do this.
    > (If I filter in Excel for unique, I will still get every row).
    > (Not sure how to use the topvalues and uniquevalues properties).
    > I appreciate any and all suggestions! Thanks!!!
     

Share This Page