In a form how do I make a numerical counter starting at 00001 and increment by 1 for each entry?
In a form how do I make a numerical counter starting at 00001 and increment by 1 for each entry?
you have an empty table with autonum counter....like tReportList_MT
copy this to the working table name, tReportList
(never use table_MT or you will loose the counter starting at 1)
now run an append query to add data to tReportList. autonum counter will start a 1.