>I have not use arrays in a while and wanted to no the best way to
>move a table into an array and evaluate the array in a FOR LOOP. My table has two fields. My code will need to look at the first field, then look at the value of the second field and do something. Do I need a double dim array?

The easiest way to do this is with a Select query into an array. select * from MyTable into array aMyArray, then you have it.