I use and append query to add records to a table. My table has an autonumber field which is updated every time a set of records are appended. I find that the autonumber field is skipping #s which posses a problem as these number are combined with another field to create are receipt # and should be flow with no gaps. I have created another field called MyCount and have used the following code [strong]MyCounter = Nz(DMax("[MyCounter]", "[Local Blotter 2]")) + 1[/strong] as my [strong]Before insert property[/strong] on the form but I find the no numbers are added to the [strong]MyCounter[/strong] field when I run the append query. It works when I input data directly into the form though, however, I need to append records in batches. I would be greatful for some assistance. thanks much
Discuss This Question: