We help IT Professionals succeed at work.
Get Started

Check for Duplicates

smithmrk
smithmrk asked
on
205 Views
Last Modified: 2012-05-11
OK, I need some help with this one!

I have a Query that reformats the data so it can truly look for duplicate items that may have been keyed differently.

For example if someone types in 01256 and someone else put in 1256 it doesn't come up as a duplicate, so I have a query with an Expression that reformats the field to 00001256, puts 20 leading zeros so the number comes out exactly the same no matter how the data was entered.

Now I tried to do a Find Duplicates Query based on this field and I'm getting (see image).

If I put the same format expression in the IN SELECT() then I get overflow error.

How can I get around this without chaning the field to Numeric it needs to stay TEXT!!!

Thanks,
Mark
FieldError.jpg
Comment
Watch Question
Infrastructure and Database Design Consultant
Commented:
This problem has been solved!
Unlock 2 Answers and 8 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE