max(Date) to return most recent dates 1

[Vie]

I found a couple of threads that partly addressed my question but still was not able to make the solutions work for my particular situation.

I need something like the following:

SELECT * FROM tblNames (join type tblDates...)
WHERE (SELECT max(DeliveryDate)
FROM tblDates)
WHERE tblNames.NameID = tblDates.NameID

The result is all the names and all the deliverydates for each name, not just the most recent one.

Can anyone steer me in the right direction on this?

Thanks,
Vie

 

[JonFer]

You didn't indicate what you wanted but this will give you the data for the most recent delivery date for each NameID.

SELECT *
FROM tblNames join type tblDates
on tblNames.NameID=tblDates.NameID
WHERE tblDates.DeliveryDate=(SELECT max(DeliveryDate)
FROM tblDates as a
where a.NameID=tblNames.NameID)

 

[Vie]

Thanks JonFer. That was the ticket!