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