Many thanks for your reply.
Unfortunately I cant get that code to work.
attached is my sample DB. could you possibly let me know where I am going wrong.
Thanks a mill.
Please would someone be able to help me out on my sample DB to get the temp vars running, I am having a lot of trouble.
My db is in a forum under temp vars, thread 1286451
Ta