I have a view with four columns: CustID, DocNum, OppNum, Date. I want to query this view and return the row with the latest date for each CustID. I want to return all 4 columns in the query. I tried using max(date) but no luck. Any help you can provide is much appreciated. Thank you.