Recent content by chemlab

I finally talked with my brother, who is a professional db developer. He recommended setting up a macro to perform a sequence of operations, which would use the first query as a make table query and then use each of the remaining 14 queries as append queries. Then, finally, have the macro export...

After thinking about the problem a bit further, I used the queries in making sub-reports, then assembled the sub-reports in the proper order to form a final report. Then, I exported the report as an Excel spreadsheet. Problem solved. Thanks.

I am building an accounting package for work, which pulls from a database and makes a local table. I then composed 15 queries (ultimately), which contain the summaries (counts of lab tests performed) for my monthly report. The queries cover 5 client types, times 3 billing levels (normal...