I have an access database and have several tables with an equal structure, ex:
NAME as text
CODE as number
RESULT as number
DATE as date
…….
and they are named
TBL_PT
TBL_US
TBL_UK
……
the table names are listed on a table:
TABLES
LIST as text
how can i do a repeated operation for each one of the TBL’s listed in LIST
ex:
copy all the names where CODE = 1
to a destiny table BRACKET
NAME as text
CODE as number.
the objective is to use the table names as parameter in several operations or queries without changing them, just by adding or deleting the table LIST
