Eliminating Duplicates

[rkapfer]

I've got a query that needs to make a table containing all fields from the source table for only unique phone numbers (multiple records contain the same phone number). Can I do this in one query?

SELECT DISTINCT [Student Info Table].[Parent 1 home phone], * INTO TABLE1
FROM [Student Info Table]
WHERE ((([Student Info Table].[Withdrawl Date]) Is Null) AND (([Student Info Table].[Stu Current Grade])<13) AND (([Student Info Table].[Contract Signed])=True));

This does not eliminate duplicates, I'm looking for an end result of only unique phone numbers along with the entire record.

 

[dakcg]

Just a thought, when I do a query like that in Access, I use "Group By" to eliminate duplicates. Could that work for you?
DAKCG