Multiple Queries Needed in a Report?

D

Dave M

Hello,

A couple of days ago I posted a similar question, but I will try to include
some more details this time.

I have several tables (shown below). I want to create a report that will
show each company grouped by type. In the details, I need each company to
have a sum of the amount in the transaction list filtered by date ranges
defined in a form. I need to have 12 different date range sums listed for
each account, and I also need to show a zero if there are no transactions for
that range. I have created the queries (10 of them) that I need to show the
correct information.

What is the easiest way of acheiving this?


1. Type
a. Type ID (one to company list)
b. Type Description
2. Company List
a. Company ID (one to Account Numbers)
b. Legal Name
c. Type ID (Many to type)
3. Account Numbers
a. Account Numbers (linked to Transactions)
b. CompanyID (Many to Company List)
4. Transactions(a linked Excel File)
a. Account Number (Linked to Account Number)
b. Effective Date
c. Balance or Instalment (contains either word, nothing else)
d. Amount
 

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

Best way to build a report 9
Incorporating the User Profile location into a document template path 1
Doughnut Chart linked with the slicer in the pivot table 0
Need some PWA help 0
Finding the right style field in VBA 0
Multiple Queries Needed? 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
VSTO C# add in Outlook.Appointment error 0

Top