troubleshooting Question

MS-Access query/module function that will update records based on certain criteria

Avatar of ExpExchHelp
ExpExchHelpFlag for United States of America asked on
Microsoft AccessVBA
6 Comments1 Solution98 ViewsLast Modified:

In need some help with an query/module function that will update records (in MS-Access) based on certain criteria.

Please view attached XLS with some sample data.   I included the three "cases" (scenario) in the call outs.   Ultimately, I may have more than these 3 cases; however, for right now, achieving the update/conversion based on the 3 samples would be a great start.

Again, as a picture is worth a 1000 words, please see the "before" and "after" for the sample data.   I'd like to accomplish the VBA in MS-Access.

Thank you,
Join our community to see this answer!
Unlock 1 Answer and 6 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 6 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