I have 2 tables, table 1 and table 2. I am trying to find the best coverage match from table 2 for the vehicle (VIN) on table 1 based upon the VINs information in table 1. I have a serious of logic steps in an If-Then-Else format, but I am not sure of the proper verbiage/syntax or how to apply in a query to generate a view of the results. Also, I would like to be able to loop the statement against the items in table 1. I have attached the tables and logic that I came up with.
Also, I am trying to fit/adjust it to the attached code.
Also, I am trying to fit/adjust it to the attached code.
Attachments
Last edited: