Need Help - VB Code for table update Access 2007

[Steve5]

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

 

[jdraw]

Update the Id field to what? Under what conditions?

 

[Steve5]

Update the [ID Column] field with an "H" for the first record
then update [ID Column] with a "D" for the next duplicate record

 

[jdraw]

Steve,
Why do you have/want to have duplicate records?

 

[Steve5]

This is for a data report that has many fields with different parts on order, but the Equipment ID is what tool the parts are ordered for. We have this project and this system asked us to supply the first record with a "H" = header and the related records with a "D". Hope that helps

 

[jdraw]

So the sample table with data you have shown is correct---is that right?

Is the data always supplied (sorted by) EquipmentID?

Do you have sample data that has to be updated?

 

[Steve5]

Yes it will be sorted by Equipment ID

 

[Steve5]

I will make a little test db

 

[Steve5]

See attached example DB. I updated two Equipment ID's with H and D so you know what I need