Thanks, it was easy, I just wasn't getting the syntax right. Thanks a ton!

w00T! It worked! Thanks a ton chief! I really appreciate that. I wonder why they changed the syntax order. I knew it had to be something like that.

Thanks again,

-Ben

Howdy,

Thanks for the reply. I just tried it out and it gave me the missing operator error again. I'm working in access by the way. I'm sure that has something to...

This is where I'm confused. You have FROM TABLENAME UPD

I thought UPD was the table that contained the information that I needed changing. Did you mean just FROM UPD?

I think I get what you're trying to do. By selecting as LIST does it make a temporary table? In your select you have a TableName, which table would that...