Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: removing duplicate field values

    is this thing read only or what? the paperclip is telling me to do things i cant do

    say column L looks like

    lamer lenders inc
    lamer lenders inc
    lamer lenders inc
    lamer lenders inc
    lamer lenders inc
    lamer lenders inc
    lamer lenders
    lamer lenders
    lamer lenders
    lamer lenders
    llama lenders

    i want a list that says
    --------------
    lamer lenders inc
    lamer lenders
    llama lenders

    the new query wizards arent working, i suck with access, plz help so i can go home

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    If you are using the QBE grid (query builder), then bring up the properties box,
    and change Unique Values to Yes.

    If you are using SQL view, insert the word DISTINCT after the word SELECT
    Inspiration Through Fermentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •