Selected related fields when using Totals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay Oken - 26 May 2006 18:41 GMT

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

Reply to this Message

Céline Brien - 27 May 2006 13:16 GMT

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

>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

Reply to this Message

John Spencer - 29 May 2006 18:13 GMT

SELECT *
FROM YourTable
WHERE Expiration_Date =
(SELECT Max(Temp.Expiration_Date)
FROM YourTable as Temp)

> 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

Reply to this Message