Thanks for all your replies, however I Have tried implementing your solution, but again I am getting an error telling me I have to Declare the variable... The SQL Statement...