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.