How do I make this query updatable (I want to be able to scroll the records and check/uncheck one fi

[Jeff]

=====
ISSUE
=====
How do I make this query updatable (I want to be able to scroll the
records and check/uncheck one field/checkbox)?



=====
QUERY
=====
SELECT 1.*, 2.*
FROM 2 INNER JOIN 1 ON 2.ID = 1.ID
WHERE (((1.Date)=(SELECT Max(tmp.Date) as MaxDate
FROM 1 as tmp
WHERE Tmp.ID = 2.ID)));



==========================
SUMMARY OF WHAT QUERY DOES
==========================
In a one-to-many query, select only the records with the LATEST date
(which is in the many side).



==========
BACKGROUND
==========
O/S = Windows 2000 Pro
Patches Installed

Software = Access 2000
Patches Installed


=========
Thanks!!!
THE END
=========

 

[Duane Hookom]

Assuming the ID field is numeric, you can try:
SELECT 1.*, 2.*
FROM 2 INNER JOIN 1 ON 2.ID = 1.ID
WHERE 1.[Date]=DMax("[Date]","1", "ID = " & 2.ID);