Welcome to SPN

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

Sign Up Now!

Query With no Repeats!

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

Tags:
  1. Bob

    Bob
    Expand Collapse
    Guest

    My Query has Clients, Horses, and percentages, how can I stop repeats. So
    same Client, horse, and percentage only show once.

    Thanks in advance.........Bob Vance
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Bob

    Bob
    Expand Collapse
    Guest

    I have them in a dropdown combo box , but I don't want any repeats...Thanx
    Bob

    "Bob" <xxx@xx.xx> wrote in message news:e7t1es$fpc$1@lust.ihug.co.nz...
    >
    >
    > My Query has Clients, Horses, and percentages, how can I stop repeats. So
    > same Client, horse, and percentage only show once.
    >
    > Thanks in advance.........Bob Vance
    >
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 28 Jun 2006 16:45:01 +1200, "Bob" <xxx@xx.xx> wrote:

    >
    >
    >My Query has Clients, Horses, and percentages, how can I stop repeats. So
    >same Client, horse, and percentage only show once.
    >
    >Thanks in advance.........Bob Vance
    >


    View the query's Properties; set the "Unique Values" property to Yes.

    John W. Vinson[MVP]
     
  5. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Bob,

    In design view of the query, right-click anywhere on the background of
    the upper panel of the query design window, and then select Properties
    from the pop-up menu. Change the Unique Values property to Yes.

    --
    Steve Schapel, Microsoft Access MVP

    Bob wrote:
    > My Query has Clients, Horses, and percentages, how can I stop repeats. So
    > same Client, horse, and percentage only show once.
    >
    > Thanks in advance.........Bob Vance
    >
    >
     

Share This Page