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 ...

summarizing data is a common report feature. You can display a running total in ... You might have noticed that the AutoNumber values in the example’s sortfield (OrderID) skips values.

I managed to delete a record on accident that aparently this half-assed system used for a 'new records' record. Now I need to find a way to add that record ...