I have a table which have some records,i need to loop through selected fields(say 10 to 14 with respect to 10)..
if it finds any data from 11 to 14(with respect to 10) the value has to append to the field 10 for each corresponding row,

sub fi_macr()
dim strsql as string
dim i as long

dim record as recordset 
set rec = currentdb.openrecordset("table1")
max_rows = rec.recordcount
no_of_fields = rec.fields.count

for i = 1 to max_rows


loop

Above code is used to get the number of records
In vba we have cells(i,4).value for selecting the particular field,Is there any equivalent method in access
Member Avatar

LastMitch

I have a table which have some records,i need to loop through selected fields(say 10 to 14 with respect to 10).. if it finds any data from 11 to 14(with respect to 10) the value has to append to the field 10 for each corresponding row,

@prathiyus

I'm not familiar with VB but I think that's not how you create a query that like. This question you ask is more related to a code related not an actually database question