Whats the best way to run many queries in a macro & make a csv rep

A

AmyNeedsHelp

HI-
I have about 4-7 tables i need data from to make a csv report. So i have
created make a table queries and then one master query to select data from
the made table queries. I was wondering what would be the best way to run
these queries and create the report? Ive been trying to run them in a macro-
also i need to delete the tables made from the queries when the report is
finished being made- any suggestions would be great! thanks!
 
S

Steve Schapel

Amy,

You can use a series of OpenQuery actions, one for each query, in a
macro to run the Make-Table queries, and you can use a series of
DeleteObject actions, one for each table, to delete the tables again
after the report is printed, and in between you can put an OpenReport
action to print the report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
Creating a Chart on form from selected data in query. 0
How to make sure one query has finished before the next runs 0
Report Query Works 2nd Time, But Not 1st 14
query to show where no data in a stated column 0
Insert Index into a Table 1
Query to show details of dataset when one type of data is still blank 1

Top