submitted this idea :
Well one quick easy way would be to run a Update Query after the
umport. Something like this should work:
UPDATE tblImportSN_Temp SET tblImportSN_Temp.BatchNbr =
Format(Now(),"yyyymmddhhnn") & [mfgCode];
As long as the execution of this query did not span more than a minute
you get what you need, with the added feature of knowning when the
records were added.
If the query is likely to take more then a second or two to execute you
could (should) compute the DateTime once and use that value for each
row to be updated. Something like:
strMyDate = Format(Now(),"yyyymmddhhnn")
strSql = "UPDATE tblImportSN_Temp SET tblImportSN_Temp.BatchNbr = " &
strMyDate & " & [mfgCode];"
CurrentDb.Execute strSql, dbFailOnError