Concatenation to variable names. Any Ideas?

  • Thread starter Thread starter davec via AccessMonster.com
  • Start date Start date
D

davec via AccessMonster.com

I have 77 different fields that are named mth2 - mth78. I want to try and use
a incremental value from a for x = 2 to 78 and try and do something like
below, but my code does not work and I know that. Any ways around it except
for using a select case with a case for each instance. I am trying to
simplify code.

For X = 2 To 78
If rst1!Mth & X = rst2!Mth & X Then
Else
rstCompare!Mth = rst2!Mth & X - rst1!Mth & X
WriteOutRecord = True
End If
Next X
 
davec said:
I have 77 different fields that are named mth2 - mth78. I want to try and use
a incremental value from a for x = 2 to 78 and try and do something like
below, but my code does not work and I know that. Any ways around it except
for using a select case with a case for each instance. I am trying to
simplify code.

For X = 2 To 78
If rst1!Mth & X = rst2!Mth & X Then
Else
rstCompare!Mth = rst2!Mth & X - rst1!Mth & X
WriteOutRecord = True
End If
Next X
Click to expand...


The syntax for that kind of reference is:
If rst1("Mth" & X) = rst2("Mth" & X) Then
 
Thanks, that was smooth. Why is it that the answer is always right in front
of your face.

Again,
Thanks

Marshall said:
I have 77 different fields that are named mth2 - mth78. I want to try and use
a incremental value from a for x = 2 to 78 and try and do something like
Click to expand...
[quoted text clipped - 9 lines]
End If
Next X
Click to expand...

The syntax for that kind of reference is:
If rst1("Mth" & X) = rst2("Mth" & X) Then
Click to expand...
 
Back
Top