I have a table full of Customer's additional ship to addresses that I am going to be importing into a ship to file that already has the 1st location for each company.
I need to add a field for location Number, which will start at 2 (since location # 1 is already in the file). Then it needs to number the rest of the records for that customer (ie duplicate customer name).
Is this possible with a query?
Here is an example of hat I am looking for:
2 Allstate 111 Main Street
3 Allstate 243 Elm Street
4 Allstate 343 Hwy 34
2 Bay Photo 367 Pecan Ridge
2 First Bank 948 Rutherford
3 First Bank 236 Addison Avenue