Macro processing

[marty581]

Is there a way to process the queries placed in a macro, sequentially? I want the results of query 1 to be available to query 2 and so on for 4 or more queries. The only way I have found to do this is by manually executing the queries one at a time (Very troublesome and impossible to use in an end user environment.)

 

[DougP]

If you use the Make table feature of a query and the use that table in the next query and so on.<br>Or better yet would be create your blank tables and the use an Append query to add records to a empty table.<br>Then you can create your 4 queries because you actually have a table to put in your queries.<br>The best solution would be to use VBA code to pick up where other parts of Access are lacking.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[elizabeth]

marty581, in case you were not aware, you can use the File/Export function to convert your macro into VBA code. This might give you a good start on writing the code, if it's unfamiliar to you.