Hi, I can't find an answer that is quite right for this but there must be a way to do it. Very simply, I have a make table query that is run monthly. I want the resulting table to have an autonumber field - which later on becomes part of a key for the line item. In the meantime though, I can't make the autonumber field any way but manually. This field should be created automatically when I run the macro that runs all of my queries. Barring a delete and then append query, how do I do it? Thanks!