Recent content by dp88

Thank for your response Plog, I appreciate it. That would work but I think that CJ_London's approach is perhaps a little cleaner although I do appreciate you sharing your idea!!!

Thank you CJ_London. Unfortunately it's access sql not sql server. I didn't realise LIMIT was available on Access sql. Your response works absolutely perfectly!! Thank you so much for your help!!

Hi All I'm trying to run an SQL query in VBA that will update the top 5 records only Below is what I have, however I keep getting an error saying SQL needs a semi colon (which I have). Would anyone know how I can update only the top x records with a WHERE clause? Thanks all for you help...