I haven't forgotten how to write update querys with inner joins, but the above SQL is how MS Access wants it, not the way you wrote it. Also, is ...
www.vbforums.com