I have 2 types of data that needs to be syncronized in access. The pieces of data are Name and Prefix. They are used in building different paths in a single loop.
I first tried to do this with an array useing a formula to differentiate the types of data. But I could not find a way to reference 2 index numbers from the array or get a array member count.
I tried next to use 2 different arrays. When doing this if I use a For each statement will not allow me to reference index 'x' in both my first and second array in the same for loop.
At this point I am stumped on where to go useing kixtart. suggestions?