Did pmanivas's answer work for you? I've been trying to duplicate your problem and use it. Maybe I'm not implementing it right.
Anyway, I tried a multi-step process with the following in SQL view of two queries:
Query#1: (Query1)
SELECT Table.accounts, Max(Table1.dates) AS MaxOfdates
FROM...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.