Selected related fields when using Totals

  • Thread starter Thread starter Jay Oken
  • Start date Start date
J

Jay Oken

I have a table which has Expiration_Date and Pmt_Amt as fields. In a query,
I want to select the Max of the expiration date and then also the Pmt_Amt
from the same record that was selected by Max Expiration_Date.


Thanks,
J
 
Hi Jay,
Create a query using your table and this two field.
Press the Operations button.
In the Operation row, select Max for the date field.
Hope that help,
Céline
 
SELECT *
FROM YourTable
WHERE Expiration_Date =
(SELECT Max(Temp.Expiration_Date)
FROM YourTable as Temp)
 
Back
Top