Return Latest Client Record and Null records

[Keiron via AccessMonster.com]

I have worked out the query to return the Latest Appointment per client, but
i would like it to also return those records that dont have a date recorded
yet. Im just not sure how or were to use the Is Null funtion.

Code is:

SELECT tbl_RequestRCPP3M.ChecklistID, Query1.MaxOfMeetingDate,
tbl_RequestRCPP3M.CYP3M, tbl_RequestRCPP3M.BP3M, tbl_RequestRCPP3M.C3M,
tbl_RequestRCPP3M.PW3M, tbl_RequestRCPP3M.O3M, tbl_RequestRCPP3M.CYP3MEX,
tbl_RequestRCPP3M.BP3MEX, tbl_RequestRCPP3M.C3MEX, tbl_RequestRCPP3M.PW3MEX,
tbl_RequestRCPP3M.O3MEX
FROM tbl_RequestRCPP3M INNER JOIN Query1 ON (tbl_RequestRCPP3M.MeetingDate =
Query1.MaxOfMeetingDate) AND (tbl_RequestRCPP3M.ChecklistID = Query1.
ChecklistID);


Thank You in advance.

Keiron

 

[Allen Browne]

Double-click the line joining the table and the query in the upper pane of
the query design window.

Access opens a dialog offering 3 choices. Choose the one that says:
All records from tblRequestPCPP3M, and any matches from Query1.

If you then look at the query statement, you will see an outer join in place
of the inner join you currently have. More info in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html