Query: working w/3 tables and problem displaying records

[azu_daioh]

Help please!

I have 3 tables:

Doctor Table (DT):
License# - Key
Last name
etc.

Payment Table (PT):
License# (relationship: 1-to-many DTT)
Date (but the column is Year: Year([Date])
Amount Paid (sum of)
etc

Outcome Table (OT)
License# (relationship: 1-to-many DT:OT)
Year
Justification
and other actions (fields) taken...

Here's what I'm trying to accomplish. I need a list of all doctors
for 2006 with the following information:
License# (payment table)
Lastname (doctor table)
Year (which is actually using the [Date] field) = criteria "2006"
Total Amount (using the sum of Amount Paid field - I need to pull over
$1M) = criteria >999999
OutcomeYear (outcome table [Year]) = "2006"
and all the other fields from outcome table


Without pulling the information from the outcome table, we have 110
doctors matching the $1M mark but I need the additional information
from the outcome table to see if the amounts are justifiable (such as
the justification, action1, action2, etc)

When I click on "Datasheet View" from Design View, it only displayed
26 doctors. 26 is the total records in Outcome table.

I tried the "join properties" but it gives me an error message.

I would like to display "all" records from "Payment Info" and whatever
records are stored in the "Outcome" table -- I need to be able to tell
which records in Payment Info needs further review (or rather when the
outcome table is not completed for the particular doctor.

Thank you!!