troubleshooting Question

Simple Update Query

Avatar of mkobey
mkobey asked on
Microsoft OfficeMicrosoft AccessSQL
8 Comments1 Solution336 ViewsLast Modified:
I need to write an update query for microsoft access that will do the following:

If a string of text in column A does not contain the letter 'E' anywhere in that string, then the fields in Columns B, C, and D will all be updated to isnull.

Its that simple.  Thank you for your help.

-MK
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 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 1 Answer and 8 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