Output Most Current Date Logged in a Query (1 Viewer)

Hello Query Experts,

I have been trying to use the “Max” function to filter down to the last date logged for a particular manager and it is not working.

I would like to see the most current WO Processed Date for Carlos Garcia. He has multiple entries with various pieces of equip and they are all appearing in my output. I only need to see the most current entry (WO Processed Date) logged for Carlos.

I have attached a sample of my db for review. The query I am using is called "qry_WO_Equip"

I appreciate any help I can get. I have been working on this issue all day. :banghead: I know, I am sad.

I apologize, I uploaded the wrong db. I am working off of the query in this db. Thank you.

I'm sure the need is different, but:

SELECT tbl_WO_Master.Equipment_Manager, Max(tbl_WO_Master.WO_Processed_Date) AS MaxOfWO_Processed_Date
FROM tbl_WO_Master
GROUP BY tbl_WO_Master.Equipment_Manager
HAVING (((tbl_WO_Master.Equipment_Manager)="Carlos Garcia"));

You may find this of interest:

http://www.baldyweb.com/LastValue.htm

pbaldy said:

I'm sure the need is different, but:

SELECT tbl_WO_Master.Equipment_Manager, Max(tbl_WO_Master.WO_Processed_Date) AS MaxOfWO_Processed_Date
FROM tbl_WO_Master
GROUP BY tbl_WO_Master.Equipment_Manager
HAVING (((tbl_WO_Master.Equipment_Manager)="Carlos Garcia"));

Click to expand...

Although It works that query groups everyone before showing the data for Carlos.

This query is more efficient because it select only the records where the manager is Carlos before it groups.

SELECT tbl_WO_Master.Equipment_Manager, Max(tbl_WO_Master.WO_Processed_Date) AS MaxOfWO_Processed_Date
FROM tbl_WO_Master
WHERE tbl_WO_Master.Equipment_Manager="Carlos Garcia"
GROUP BY tbl_WO_Master.Equipment_Manager;

Yeah, I was lazy because I figured the target would move anyway. Shouldn't have done that.