0

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
2
Contributors
1
Reply
18
Views
4 Years
Discussion Span
Last Post by LastMitch
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.