Query Total Date

[AdamQuestion]

Hello,

I am sure this is simple but I cannot find an existing thread.

I have a query where I display a list of steps(details) to several projects and a Due date and completed date. The Due date is a required field and the completed date is not. My query is set to Totals and it finds the Last Due Date out of the steps no problem. I am also looking to find the Last Completed Date but I want it to display a blank field if there is no date listed in one of the steps for a specific project. Any help would be appreciated.

Thank You

SELECT tbl_Details.DataID, Last(tbl_Details.DueDate) AS LastOfDueDate, Last(tbl_Details.CompDate) AS LastOfCompDate
FROM tbl_Details
GROUP BY tbl_Details.DataID;

 

[alansidman]

I think that you want to remove the "last" criteria from the completed field.

 

[AdamQuestion]

The user would enter several steps (details) for a given project and they would place in a field when they completed that step. I would like the query to display the latest completed date. However, if the project has not been completed (all completed date fields filled in) I would like to display nothing.