Hello, I am very new to SQL and Access - most of my experience is in VBA and Excel. I am trying to add "max" to the "TXN_Number" field...Any guidance would be much appreciated.
Code:
SELECT t.ID, t.TXN_Type, t.Program_TXN_Number, t.TXN_Date
FROM PURCHASING_DB AS t INNER JOIN (SELECT ID, max(TXN_Date) AS MaxDate FROM PURCHASING_DB GROUP BY ID) AS tm ON (t.ID= tm.ID) AND (t.TXN_Date = tm.MaxDate)
WHERE (((t.TXN_Type)="Purchase" Or (t.TXN_Type)="Initial Balance"));