Access Group By
I'm still converting over from Access. I'm trying to recreate the Access Query functions, specifically the "Sum" functions to group across records.
Approximation: Group(MemberID), Sum(Nz(Don+Dues+Premium)), Last(Submitted), Where(Submitted>=1/1/2012)
SELECT [5Donation].MemberID, Sum(Nz([Donation])+Nz([Dues])+Nz([Premium])) AS SumOfAmount, Last([5Donation].Submitted) AS LastOfSubmitted
GROUP BY [5Donation].MemberID;
And on a related note, can I do SQL in FM? It looks like it's only valid through the ODBC interface.