Member Avatar for prathiyus

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
  • 147 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by LastMitch
Member Avatar for 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.