Update table based on Max date link

[janmack79]

Hi All,

I am trying to update a field in my 1st table based on the remarks in a 2nd table. But in the 2nd table shown called Remarks I want to take the line with the Max Date in that table to update to the MK TBL MGMT Report Shell. What would I need to enter in the criteria line so it only pulls the row with the max date?

[ranman256]

you need 2 queries,
Q1 to get the max date and ID:
select Max(date),ID sort Desc

Q2 will then use Q1 and data table to pull all records joined to Q1:
select tData.* from tData,Q1 where tData.ID = Q1.ID

[janmack79]

Ok thought there might be a way to do it with in the 1st query but having two queries is simple enough to do as well. Thank you