Find Duplicates Query

E

ennis

When I try to use an expression as the field to look for
duplicates in i get the following error: you tried to
execute a query that does not include the specified
expression 'count(*)>1 and Left([contact name],5)=' as
part of aggregate function.
When i tried to use the LEFT function as just a criteria
under the Contact Name field, it only pulls up about 37
entries out of 8,000. Any help would be greatly
appreciated.
 

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

Top