Combine 3 queries into ONE REPORT. PLEASE HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three separate queries with some of the same tables in each query. How
would I get all three queries to work together to make one report? I had to
break down the queries this way because they were too complicated for one
query. There are 14 fields to this report over three queries. Now the catch
is. The need to be exported to an Excel spreadsheet. How can or where do I
begin to do this correctly. The first is to make the queries execute
correctly and the second step is to export to Excel. PLEASE HELP!
 
If I am understanding you correctly - you should base your query on a
previous query and so on to keep narrowing down your data..... on your final
query - you can then create a macro to export to excel - Action TransferExcel
hope that helps
 

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

Combination Report 4
Multiple Queries for Microsoft Access Report 5
Multiple-query report help 1
Report Won't Run - Query Is Too Complex 7
query values vs. query results 3
Report exporting different data from what is on the report 1
passing parameter from a command button to a report 2
one report based on multiple queries 2

Back
Top