Sorry Naomi;
I did try your suggestion after i posted my code for Sergey to look at, but i didn't get a chance to reply to you.
Both your suggestion and Sergey pointed me in the proper direction. I think i will be able to speed up select statment. I will let you know the outcome.