Newbie MS Access question

Discussion in 'OT Technology' started by Caanon, Apr 17, 2005.

  1. Caanon

    Caanon OT Supporter

    Joined:
    Nov 16, 2003
    Messages:
    685
    Likes Received:
    0
    School assignment, have everything filled in and done, just need to know how to do one last part.

    I need it so items in the first column, dont repeat, and are left bank. It's sorted in ascending order by the first column and it needs to be so the the first occurance of text in that column is listed, and the the repeats are blanked out. By blank out I mean just the first column in the row, the rest of the row has to display. I hope I explained that clearly. Teacher's handout said this was possible, but I must have missed it if he said how to do it.

    Thanks for any help
     
  2. Penguin Man

    Penguin Man Protect Your Digital Liberties

    Joined:
    Apr 27, 2002
    Messages:
    21,696
    Likes Received:
    0
    Location:
    Edmonton, AB
    IIRC, there's a box somewhere in the query designer where you can select Unique, so it'll only give you results with a unique value in the first column (ie the first result it finds with each first-column value). I think this might be what you're looking for.
     
  3. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Is this on a report?
     
  4. Caanon

    Caanon OT Supporter

    Joined:
    Nov 16, 2003
    Messages:
    685
    Likes Received:
    0
    Sorry Forgot, this would be during a query


    Edit: NM I found what I needed.
     
    Last edited: Apr 17, 2005

Share This Page