Query Question

Results 1 to 3 of 3

Thread: Query Question

  1. #1
    Barkus Guest

    Default Query Question

    Is there a way to make a query so the following occurs:<BR><BR>You have a DB that has the following: A,A,A,A,B,B,B,C<BR><BR>I want a Query to result as follows: A,B,C<BR><BR>Any ideas

  2. #2
    Mr Swifty Guest

    Default RE: Query Question

    You could be looking for the magical SELECT DISTINCT Field etc.

  3. #3
    Barkus Guest

    Default RE: Query Question

    I think this is the direction I need to go, but there is a catch.<BR>For each A,B,C in my database there is a unique ID (ie. field name ID). <BR><BR>When I inserted the new Select statement "Select Distinct ID,Name,City,State,Category FROM RS" I still get all the records. I know that ID is the problem, but are there any suggestions

Posting Permissions

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