[SOLVED] Help on lookup to pull most recent value based on most recent date Hi All,

I have an audit table that records the change to an account's information. I need to look up the most recent *datetime* and *street* address for the account only when the street_updated column is True and look it up by the *cust_id.*
In the example dataset below, I would expect my...
https://www.excelforum.com/sho....wthread.php?t=142304