Hi there
Hopefully someone can help me.
I have a situation where I am using a maketable query to create a table and then I need to use append queries to then add additional records to the created table - some of these are just run once and some multiple times.
if possible, I do not want to hard code the query multiple times i.e.
etc
So is there a way I can run the make table query and then get some sort of loop to run the append query a number of times ?
Thanks in advance
Rich
Hopefully someone can help me.
I have a situation where I am using a maketable query to create a table and then I need to use append queries to then add additional records to the created table - some of these are just run once and some multiple times.
if possible, I do not want to hard code the query multiple times i.e.
Code:
DoCmd.OpenQuery "qryCreate_1"
DoCmd.OpenQuery "qryAppend_1"
DoCmd.OpenQuery "qryAppend_1"
DoCmd.OpenQuery "qryAppend_1"
So is there a way I can run the make table query and then get some sort of loop to run the append query a number of times ?
Thanks in advance
Rich