I have a query with both a date and time field. I want the results to return only the most recent for each projectID#. I think I need a DMax function, but it’s giving me trouble.
I put the 2 date and time field together in a concatenated field (only a space between date and time) named “MgrDate&Time”. Then I tried many variations of the following formula in it’s own column, to no avail.
Sort Order: DMax(“MgrDate&Time]”,”qry Manager Status”)
–and —
Sort Order: DMax([MgrDate&Time],[qry Manager Status])
Any help would be appreciated. THANKS.
