Folks,
below I have two columns, the [EquipmentID] is what I have in a Access table and the [ID Column] is what i need updated in code. Can someone help me with the how the code would work to update [ID Column] field?
H = Header or first record unique Euipment ID
D = Duplicate of Header
ID Column EquipmentID
H 1111
D 1111
D 1111
D 1111
D 1111
D 1111
H 2222
D 2222
D 2222
D 2222
H 3333
D 3333
below I have two columns, the [EquipmentID] is what I have in a Access table and the [ID Column] is what i need updated in code. Can someone help me with the how the code would work to update [ID Column] field?
H = Header or first record unique Euipment ID
D = Duplicate of Header
ID Column EquipmentID
H 1111
D 1111
D 1111
D 1111
D 1111
D 1111
H 2222
D 2222
D 2222
D 2222
H 3333
D 3333