K
kcirino
I am working on bringing in data from another division. The program that I
use to bring this into our ERP system requires a line number. Is there a way
I can next number by sales order number and restart the number to 1 when the
sales order number changes? If I can do this through tables (autonumber) or
queries I will need help understanding how to use Visual Basic coding in
Access since I am fairly new to using Access for data scrubbing.
Example:
Sales Order # Line #
1 1
1 2
1 3
2 1
3 1
3 2
3 3
use to bring this into our ERP system requires a line number. Is there a way
I can next number by sales order number and restart the number to 1 when the
sales order number changes? If I can do this through tables (autonumber) or
queries I will need help understanding how to use Visual Basic coding in
Access since I am fairly new to using Access for data scrubbing.
Example:
Sales Order # Line #
1 1
1 2
1 3
2 1
3 1
3 2
3 3