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 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.
Attachments
Last edited: