AnsweredAssumed Answered

obtain maximum value of one field for each entry in another field

Question asked by HB on Jul 22, 2015
Latest reply on Jul 27, 2015 by philmodjunk

Title

obtain maximum value of one field for each entry in another field

Post

I must have brain freeze this am.  How can I obtain the maximum value of one field for each entry in another field that shares the same data in another field on the same table.

 

ie  In a 'WorkOrder' table, find the last 'StatusDate' for every 'Client' who has a 'WorkorderNum' whose 'Status' = "complete"

Outcomes