Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Reporting with relational Access database

Avatar of akb
akbFlag for Australia asked on
Microsoft Access
3 Comments1 Solution238 ViewsLast Modified:
I have four tables in an Access 2013 database:

Customers
Patients
Invoices
Payments

The Patients are animals, so each Patient belongs to a Customer.

I'd like a report which lists the customers, followed by the Patients belonging to the Customer, then the invoices which belong to the customer and finally the Payments made by the Customer.

It would look something like:


Cust #123  Mr John Smith
123 Smith Street
Smithton  12343

Patients:
#2534 Fluffy
     DOB: 01/01/2001
     Vaccinated: 01/06/2001

#8374 Spot
     DOB: 05/06/2012
     Vaccinated: 04/07/2013

Invoices:
#14253  02/02/2002 Fluffy
     Cut paw
     $35.00

#73546 03/03/2013 Fluffy
     Headache
     $40.00

#82735 04/04/2013 Spot
     Fur ball
     $37.50

Payments:
#73637 10/02/2002
     Inv#14253  $30.00
     Inv#14253  $5.00

#28282 05/05/2013
     Inv#82735  $37.50


<Page Break>

And so on for each Customer


I'd be really keen to get a working example of this.