Append Query and Dmax()

5 pts.
Tags:
append query & Dmax()
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following