Ok, I found a way to run the query so that is no longer a problem, however the query that I am running is an update query and that means every time I make an update using this query it informs me that I am about to make an update to a table and wants to know if I want to continue, so I have to click on the "Yes" button and then it says that I am about to update a certain number of records and again I have to click on "Yes" to continue.
Thank you in advanced,
TPowers