For those of you forced to use Microsoft Access , thus needing to write bad SQL , here's how you would write an UPDATE table SELECT FROM...