How Do I Append Records In Sequence Using An Access Append Query
I want to use an append query to append records to a table (tblFood - See attached). Also, I want to automatically update the VoucherNo field in sequence. For example I wanted to enter an ending voucher number and the query will append records beginning with the next number in the sequence and ending with the number entered by the user. In addition I want to enter a name in the FullName field that will be appended along with the voucher number Food-Voucher-V1-1-1.accdb
Web Languages and StandardsDatabasesMicrosoft Access