Besides creating a new table and choosing the autonumber field, how do I create a query field that adds an ID number that automatically numbers itself (from 1,2,3,4,etc), when I query a table.
For example, I have a table with one field
Names
------
John
Frank
Larry
How do I create a query...
If I have a table that tracks inventory, and each record denotes a transaction that either adds or subracts from inventory. How do I create another field that automatically calculates the balance for each record?
The calculation would entail adding or subtracting from the current record, as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.