Help with a report query

[TWheatley]

Hey guys, I am new to Access. I want to get a report from a database and I have no idea where to begin. I need the report to look like this:

INSURANCE COVERAGE SUMMARY REPORT

Insurer Service NumberCovered CostCovered

GreatWest Life

Cleaning 14 7550
Extraction 5 500
Filling 10 1500

Insurer Total 9550
Canada Life

Cleaning 22 13250
Extraction 16 7250
Chat 22 25000

Insurer Total 45500



Report Total 70500

So far my pseudo code is this:

SELECT p_insurer, s_name, SUM(as_quantity), SUM(as_quantity * s_costperunit)
FROM person, service, app_svc, appointment
GROUP BY p_insurer, s_name

Basically I am wondering how to properly use the SUM properties, and how to get them to only sum the quantities of each service. I have four tables: appointments, service, person, and one the links appointments with the services requested. Any help you guys can give would be appreciated.

Also here is my table view of my databases:

[pbaldy]

For starters, you need joins between your tables. If you create the query in design view, Access should add them for you since you have relationships set up.

[TWheatley]

Any chance I could be pointed in the right direction with the SQL script for it?

[pbaldy]

Here's an example from a db I have open:

SELECT tblReservations.ResNum, tblReservations.ReqDateTime, tblCarTypes.CarDesc
FROM tblReservations INNER JOIN tblCarTypes ON tblReservations.CarType = tblCarTypes.CarType;