Thanks so much for all that code. I used the first part and it worked. It took awhile but it worked. I'm not good enough at this stuff to try the other one. You're right in that it's a lot better to make only 2 calls to the database but...oh well. I'm still learning this stuff. Thanks again.