duplicate phone query

L

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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate Phone search 4
Query help... 3
invalid argument 3
Append Query resulting in duplicate records 4
Listbox will not Requery AfterUpdate 5
Move (not append) records from one table to another 3
Can I cast a generic list, or do I need another approach 2
form's VBscript disabled after the first save 2

Top