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!