I need to cycle through each record, select two fields and perform some checks on those values, bin appropriately and then go to the next record until the end of the full set. How would I do this in a macro? I currently have it picking up all the unique identifiers, and getting a count. but after that I could figure out how to get it to select the two fields that I need that are associated with the unique identifier. If I was able to pick up the fields associated with a single unique id, how would I then return back to the full list to go onto the next id?
Please try to describe what you are trying to accomplish in terms of the output and the data. If you are going to loop through 400K rows I think you are going to be waiting quite a long time between each click.
