Results 1 to 4 of 4
  1. #1
    hoachen is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    17

    find specific data

    Using Access 2003,XP OS

    I am trying to run a query from a table (See the attachement). I want to run a query that check the phone#, if the phone number is the same then i want to eliminate the phoneType where is equal to "Cellphone".

    I used the query here but not working due to multiple fields have the same input.



    SELECT distinct Sheet1.Phone#, Sheet1.Fname, Sheet1.LName, Sheet1.Dept#, Sheet1.Address, Sheet1.PhoneType, Sheet1.ClassNumber
    FROM Sheet1;
    WHERE Sheet1.PhoneType = "Cellphone"

    I searched the google and found some said that access does not support distinct clause!

    Please help!
    Last edited by hoachen; 08-18-2009 at 05:45 PM. Reason: Add attachement

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm not very strong in SQL but try DISTINCTROW instead of DISTINCT.

  3. #3
    hoachen is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    17
    Quote Originally Posted by RuralGuy View Post
    I'm not very strong in SQL but try DISTINCTROW instead of DISTINCT.

    Thank you for trying to help. I tried the the distinctrow but not working either then I search on MS access help forum and MS Access does not support distinct or distinctrow so I use other method to complished what i want. THanks again for your help.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like you got it working but where did you fine that MS Access does not support distinct or distinctrow? I think it does.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 07-16-2009, 02:42 AM
  2. Open to specific form
    By ecpike in forum Forms
    Replies: 2
    Last Post: 06-12-2009, 08:32 AM
  3. Find out changed data
    By Papote in forum Programming
    Replies: 1
    Last Post: 04-27-2009, 08:19 PM
  4. Find data, load data, and save as a new record
    By hawzmolly in forum Access
    Replies: 0
    Last Post: 10-05-2008, 03:18 PM
  5. Automatic Data Entry on a Specific Date
    By alanbrai in forum Programming
    Replies: 2
    Last Post: 11-14-2007, 05:15 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums