Database cleanup

[paultri]

I need to create a query that will only show entries that do NOT have the phone number field in the following format (xxx)xxx-xxxx

is it possible to query and bring up only entries that are NOT formated this way?

Thanks in advance!

 

[dcx693]

The ? character entered into a query stands for a single character (whereas the * character can stand for any number of characters). Just set your criteria line to something like this:
Not Like "(???)???-????"

 

[paultri]

Thanks! that gave me exactly the results i was looking for!