I am using Access97.
How can i go to the end of a record? what i really need is to go to the end of a record and then go backwards 3 columns and capture that value into another field. That other field is called Loc2 and i programmically added it to the table.
Set fld = tdf.CreateField("Loc2", dbText, 10)
tdf.Fields.Append fld
for example:
F1 F2 F3 F4 ... F43 F44 F45 F46
abc xd dd 1.22 d4r 4r ty 1.88
i want to capture the value in F44 (which is 3rd from the last).
but another record might only have 8 records:
F1 F2 F3 F4 F5 F6 F7 F8
abc xd dd 1.22 d4r 4r ty 1.88
and i want to capture the value in F6 (which is 3rd from the last).
But, this table is being updated weekly with data from Excel so the total number of columns can change weekly. The table currently has a total of 43 columns (F1...F43). Next week, it might have 30 columns.
Thanks!
How can i go to the end of a record? what i really need is to go to the end of a record and then go backwards 3 columns and capture that value into another field. That other field is called Loc2 and i programmically added it to the table.
Set fld = tdf.CreateField("Loc2", dbText, 10)
tdf.Fields.Append fld
for example:
F1 F2 F3 F4 ... F43 F44 F45 F46
abc xd dd 1.22 d4r 4r ty 1.88
i want to capture the value in F44 (which is 3rd from the last).
but another record might only have 8 records:
F1 F2 F3 F4 F5 F6 F7 F8
abc xd dd 1.22 d4r 4r ty 1.88
and i want to capture the value in F6 (which is 3rd from the last).
But, this table is being updated weekly with data from Excel so the total number of columns can change weekly. The table currently has a total of 43 columns (F1...F43). Next week, it might have 30 columns.
Thanks!