AdamQuestion
New Member
- Joined
- Jan 17, 2006
- Messages
- 46
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;
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;