duplicate phone query

[lmv]

I have a search form with a query but it is returning records where the phone
field is blank as well as the ones that are dupes.
How can I filter out the records where phone # is blank?
Thanks!

SELECT DISTINCT [Name List].PhoneNumber, [Name List].Inactive
FROM [Name List]
WHERE ((([Name List].PhoneNumber) In (SELECT [PhoneNumber] FROM [Name List]
As Tmp GROUP BY [PhoneNumber] HAVING Count(*)>1 And [PhoneNumber] = [Name
List].[PhoneNumber])) AND (([Name List].Inactive)=False))
ORDER BY [Name List].PhoneNumber;

 

[lmv]

by the way this posted twice BUT I rcvd a notice that it hadn't ... sorry!