Peraphs I,m stupid insert into

[sal21]

I have this loop for next and a table with many fields named CAMPO4, CAMPO5...

Code: Select all

CONTA=4
For I = 17 To 64
If CHECK_B.Range("H" & I) = "X" Then

CONTA = CONTA + 1
End If
Next I

I want to insert the "x" value in a field base a union of CAMPO&conta...
how to?

[HansV]

Into which record do you want to enter the value?

[sal21]

here...

[HansV]

Please try to explain more clearly what you want to do.

[sal21]

Please try to explain more clearly what you want to do.

In neffect is a dynamic sql query. example.

The for next loop intercept "X" in CONTA=5 and in CONTA=9, dinamiclly create insert into query similar:
insett into mytable (CAMPO5,CAMPO9)values("X","X")

The for next loop intercept "X" in CONTA=5 and in CONTA=9 and in CONTA=11, dinamiclly create insert into query similar:
insett into mytable (CAMPO5,CAMPO9,CAMPO11)values("X","X","X")

In effect CONTA set the right number of field CAMPO (CAMPO&CONTA)

i hope now you undesrtsand me.

[HansV]

Where are these values CONTA=5 etc.?

[sal21]

Where are these values CONTA=5 etc.?

CONTA is the counter into the for next loop

[HansV]

And where do we find the "x"?

[sal21]

The "X" value

If CHECK_B.Range("H" & I) = "X" Then

CONTA = CONTA + 1
End If

[HansV]

Sorry, that doesn't make sense.