troubleshooting Question

Update Query, using Replace

Avatar of pdvsa
pdvsaFlag for United States of America asked on
Microsoft Access
31 Comments2 Solutions478 ViewsLast Modified:
Experts,

I am not sure why the Update query is not working in the attached db.

There are special characters and I am stipping them out.
I have Replace to "replace" any "-" and any "0" but it doesnt seem to want to update.

I only have the suspect record in the db and I have copied this record below between the 2 tables:

0045-000-20002074   (this one has 3 0's 0 between 45 and 2 and "-")
00450020002074        (this one has 2 0's 0 between 45 and 2 and no "-")

My understanding is that the Replace will strip the special character "-" and "0" and compare only on the remaining numbers: 452274 (no 0's or "-")

On my end, the update query has 0 records to update.  
If I MANUALLY remove the "-" in import-CSM2 then it will update but the Replace is suppose to do this automatically (I think)

Do you see what the issue is?    thank you

2010 format
EE---Copy.accdb
ASKER CERTIFIED SOLUTION
ButlerTechnology

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 31 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 31 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros