I am running a loop and in it I have eight querys the are conditional
and I was wondering if there is a way to reset them to null after each
loop. What is happening is that I pick the first record it runs fine
then I pick the second record and if one of the querys is not processed
because the conditions are not met it keeps those values in play. and I
get record one's information in the record two's loop.
Ie
Record ID Roommate1.First Name
------------------------------------------
1 Jon
2 Jon (Should be blank)
3 Jackie
4 Jackie(Should be blank)
Thank you for your time
Jim
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
