J
jesperl3
We have a situation here, followings are the table we have,
a) APNEXTSYS, Last SysDocID, keep tracking the last document sequence
number
b) Ms Excel File, APFILE, to be import into Access Table, however
incremental number field need to be inserted.
c) APLIN, Ms Access to be updated using Append/Update Query.
What would be the best way to insert the incremental SysDocID in the
Update/Append Query, and subsequently, post the Last SysDocID from the
query back into APNEXTSYS.
The incremental number field is generated in Query, For the First Time,
it always extract the Last SysDocID, and insert the next document ID by
+1... after all records generated with incremental number, last
document ID shall be updated back to the table APNEXTSYS for future
reference.
Suggestion, example, sample code help, would be much appreciated.
Thank you
a) APNEXTSYS, Last SysDocID, keep tracking the last document sequence
number
b) Ms Excel File, APFILE, to be import into Access Table, however
incremental number field need to be inserted.
c) APLIN, Ms Access to be updated using Append/Update Query.
What would be the best way to insert the incremental SysDocID in the
Update/Append Query, and subsequently, post the Last SysDocID from the
query back into APNEXTSYS.
The incremental number field is generated in Query, For the First Time,
it always extract the Last SysDocID, and insert the next document ID by
+1... after all records generated with incremental number, last
document ID shall be updated back to the table APNEXTSYS for future
reference.
Suggestion, example, sample code help, would be much appreciated.
Thank you