you win!

much simpler than mine...i still have a lot to learn.

thanks for the help,

ben

thats for the help.

yeh im quite new to sql, and self taught at that. in what way should i alter the code to make it "nicer"? just for...

thankyou for the quick response! it works a treat

ben

thanks for the advice. think i should be able to sort it now

thanks a lot for the help. got it working now