Many thanks, I didint know you could run the exe from the command window. But the strange thing with this error is that I dont have any aggregate functions within the SQL, In fact there is only one in the whole program and thats totaly seperate from the area that is giving the error.

Ashley