Counter

[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

 

[Douglas J. Steele]

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.