>>It's a good idea to use a loop, but we need a different field to use, say, Processed. Otherwise you will be running an infinite loop, since not all people are farmers.
>
>Nope, it wouldn't go to infinite loop.
>WHERE tblCamp.isFarmer = 0 will filter only these records where the people are not farmers.
>INNER JOIN will ask only for these that ARE farmers :-)
Tricky! :)
If it's not broken, fix it until it is.
My Blog