Cynthia,
Thanks for reviewing by code. The reason that I am attempting to use a do until loop is that I have a table where mulitple rows could return matches to my criteria and I only want the results of the 1st row that matches my criteria to be returned.
So from my example I only want id = bill if the suspected value is 80 and the prov is 015. Currently I am also getting a row where the suspected value is 80 and the prov is 044, because it matches my criteria.
My goal is to have a process that checks multiple conditions and selects the first row if it mathches the criteria and then end the program or proceed to the next row etc.
Michael
... View more