The AutoNumber field makes an excellent primary key, and Access does not allow two AutoNumber data types in an Access table, only one. Add a new row to the table and name the field the name of the ...

There's no built-in way to generate a running total in your Access queries, but you can still get the job done if you set up your table correctly and build the right expression. Database expert ...

Now I run into the problem of importing my old data while maintaining my table structure, namely the autonumber fields.