I have a table in Microsoft Access that has duplicate customer numbers. I want to auto assign a number to the records,i.e. 1 thru 6. But reset to 1 each instance the customer # changes. Is there any easy way to do this?. Thanks
Software/Hardware used:
Microsoft Access 2003
ASKED:
June 7, 2010 6:38 PM
UPDATED:
June 7, 2010 6:46 PM