Creating a variable from an expression

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Mike Blair

    Creating a variable from an expression

    I have a loop in a MS Access application of which I would like to
    number the variables within the database as follows:

    tbl
    rev1
    rev2
    rev3...

    I would like to do the following:

    for i=1 to 20
    rs![rev&i] = expression

    next

    The rs![rev&i] will not work??????

    Please help!
Working...