I have a query that I want to run at about 10pm every night (when everyone has gone home) , to make it even more complicated it queries from sage and creates a table each night (that i want to overwrite the old table) and it will need to enter in the sage login information :(

Does anyone know how to do this as to be honest, it has me at a bit of a loose end, I guess it would be a macro, but I have no idea of the commands used

Hi,
why double posting this?
You could create a macro which executes your query and then call this macro with the windows scheduler at whatever time you want. Check this for more: http://support.microsoft.com/?kbid=230575

HTH
Good luck

Yeah our server was being abit slow and timed out, so I re-did it and it turned into a double post, so I deleted the other ones, hmm thanks, I'll give that a go

You're welcome.
Glad I could assist.
Good luck on future projects!