J
Joe_Access
I have a table with several hundred items in it. I have a field that
contains the manufacturer. In the same table I have a field called Item
Number. I want to run a query to number the items for each manufacturer from
1 to n
Example data
"Manufacturer" "Item Number"
A 1
A 2
B 1
A 3
C 1
B 2
B 3
C 2
Can someone help me please
contains the manufacturer. In the same table I have a field called Item
Number. I want to run a query to number the items for each manufacturer from
1 to n
Example data
"Manufacturer" "Item Number"
A 1
A 2
B 1
A 3
C 1
B 2
B 3
C 2
Can someone help me please