Recent content by WAsh

Cornerstone, your suggestion proved the correct diagnosis. When going through the unformatted Telephone Number fields of the table, I found almost 500 records that maintained the input mask; and, after manually getting rid of the parentheses, spaces, and hyphens, my duplicates disappeared from...

Well, thanks for each of your responses. Having just received them, I've had no chance to work with them, but, following is the SQL Statement created by Access that gives the results (and, by the by, this is the first time I've had difficulty with Unmatched Query results).<br><br>SELECT...

Thanks for your input, Elizabeth and Doug...but, sorry, it still pulls invalid results.&nbsp;&nbsp;Either way I choose the tables, and regardless of what fields are shown in the result, the unmatched query continues to perform with a high degree of inaccuracy (in one case 50%). I welcome any...

I'm upgrading a rather primitively designed database with approximately 4500 records. I've established certain base tables that are properly linked. One of the tables is associated to the old database by a Primary Telephone Number. When I run a Find Unmatched Query based on the Telephone Number...