VBA HELP

  • Thread starter Thread starter JIMBO
  • Start date Start date
J

JIMBO

What if I have more than one query, say for example:
SqlStringA = Transform Query code
SqlStringB = Select Query Code
SqlStringC = Joins SqlStringA and SqlStringB
SqlStringD = Appends SqlStringC to a table

In this case I have four differnt querys, however if I
wanted to write this all in VBA how would I go about that.
I guess my ultimate question is if the case arises, how
would I execute a query in VBA and store the results in
memory to use in a later query also written in VBA?
 
Hi,


If the queries are saved queries, execute the last one.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top