OpenQuery, Close

[chancer1967]

A simple question... i think


I have a whole string of queries that I need to run in order. So I created a macro that does just that. OpenQuery, OpenQuery, blah, blah

When I run it I get a screen full of windows, so then I had to insert a load of Close commands after each OpenQuery.


Was there a simpler way of doing this? A way to make the query run, erm, discretely?


Thanks

 

[FoFa]

These queries must be select queries, since action queries don't display. So I guess the question would be, why would you run a select query if you don't want to see the data?