I want help in the sql statement to pull 3 columns from a table which are
ID, Max(CalibDueDate), DoneBy from (Max(CalibDueDate).

Please see the attached Sample Data.
thanks for all the help,
Sam

Trying to do something with a null field involved can cause problems. I was going to suggest creating a max query, to find the max date for each ID

The only way it groups correctly is to ignore the record with the Null date
query name: qryMax
SELECT SampleData.ID, Max(SampleData.CalibDueDate) AS MaxOfCalibDueDate
FROM SampleData
WHERE Not ISNull(sampledata.calibduedate)
GROUP BY SampleData.ID;


Then I would link this query back to the original table in a second query

SELECT SampleData.ID, SampleData.CalibDueDate, SampleData.DoneBy
FROM SampleData INNER JOIN qryMaxDate ON (SampleData.CalibDueDate = qryMaxDate.MaxOfCalibDueDate) AND (SampleData.ID = qryMaxDate.ID);

This unfortunately does not give you the desired output because of the Null date field.

I would think that calibration due date is best handled by storing the last calibration date and the calibration frequency (in days). Therefore to get the calibration due date you would just add the frequency to the last calibration date. Since the due date is a calulated value, you would not store it.

You transposed one of the numbers in the JPG file which didn't help.

Try one of the techniques in The Access Web article.

Van,
You are right I missed ID # 4534.
thanks!

You're welcome... Glad we could help...