Counter

  • Thread starter Thread starter Hasan
  • Start date Start date
H

Hasan

Hi,
i am importing data from an old database to a new 1. in
the new database i need an auto number that numbers the
products for a customer but on the change of the customer
i want the counter to reset to 0 and start counting
again. in other words to add 1 to the previous number.
in Access using append query how can i set this fields
so each time the customer will change during the import
teh counter will reset.
Thanks
 
There's no way to automate such behaviour in Access. You'll need to use VBA
code to read your incoming data row by row, and handle the processing
yourself.
 
Back
Top