We help IT Professionals succeed at work.

Access update table field (yes\no) according to partial match with another table field

Dr. Atad
Dr. Atad asked
on
34 Views
Last Modified: 2017-05-07
Hello
In Access, I have table1 contain fullname, ID, YES\nO FIELD
table contain somename,ID(not match the Fullname ID)
I want to update yes\no field to yes if the somename match partially the fullname

I appreciate any help
thanx
DR. Ayad
Comment
Watch Question

Software Tead Lead / Business Analyst / System Analyst / Data Engineer / Applications Consultant
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
thank you very much
Ryan ChongSoftware Tead Lead / Business Analyst / System Analyst / Data Engineer / Applications Consultant
CERTIFIED EXPERT

Commented:
is that worked for you? you may proceed to close this question then
Ryan ChongSoftware Tead Lead / Business Analyst / System Analyst / Data Engineer / Applications Consultant
CERTIFIED EXPERT

Commented:
Suggestion solution should able to resolve the issue that being asked.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.