Update specific record position in table using recordset

[afromanam]

Hello,

Good morning,

I have a question, hope someone can help me.

I have a table with say, 5 columns, each named A,B,C,D,E

The table was imported from Excel, so picture please this:

The first 20 rows (or records) of the imported table are blank, what i need to do is to find the first record position (21) in column B (which in Access would be called a field) which is not blank and in the previous row (or previous record) add a string called "IMO".

What i thought is to use a recordset, use a loop cycle until the length of the record is not 0, then use the AbsolutePosition - 1 in a variable and use that to mark the row number (or record number) where i should update.

But the hard part is, how do i update the table?, maybe with an update query using docmd.runsql, but the problem is that i don't know how to update specifically "cell B20", or in Access terms, field B, record number 20.

Thank you and best regards

Please help

[Delerna]

Hi afromanam
I have to ask, is this a one off task. Updating the B field in the first 20 rows to "IMO" I mean. If so it would be far simpler to just open the table and update them manually.

If it's not a one off task, then is it always the first 20 rows and is it always 20. If so then you could use vba to open a recordset object on the table and loop through the recordest for the first 20 rows doing an update on the B field as you go. Then you could do an update on the recordset at the end so that the changes get committed back to the table.