Lynn,

I ending up removing the temporary table for the source data and used the main query directly in the update code you wrote - I only added this additonal temp...

Lynn,

Just wanted to thank you again, apart from a couple of missing "@"' your code worked perfectly. It is a much more elegant process than what I came up...

Lynn,

Thank you very much for you time and effort in helping me with this. I did read the link in your email about generating the code to create the...

Lynn,

I just realised that the server running the application is one that hasn't been upgraded to 2005 and is still running 2000 - I also noticed that there is a...

Lynn,

Thanks very much for your offer of assistance, below is a sample (10 rows) CSV file from the major query providing the source data. Further down is the contents...

Lynn,

Thanks for the reply, the "what i'm trying to accomplish" is to move an access database to an SQL backend and keep the access forms in the front end. ...