Results 1 to 2 of 2

Thread: Show only once

  1. #1
    Lounger
    Join Date
    Apr 2010
    Location
    Sofia
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a query consisting of the fields productid and customerid.It shows the products bought by the customers.These products are bought with different orders.Therefore they are repeated many times for one and the same customerid. I want to show however only the clients that have bought this product.Therefore is it possible to restrict the query and show the customerid for a given productid only once.
    For example

    Productid customerid

    1409 3000
    1409 3000
    1409 3000
    1409 3000

    Is it possible for the query to show only:
    1409 3000

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    One of the properties of a query is "Unique Values" only - if you set this to yes, it will return 1 record for each unique value in your query.
    Wendell

Posting Permissions

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