Help with Dmin function

[ohthesilhouettes]

Hi I have data about treaty names for a given country for a given year and for a given action.



TreatyName Country Year Action
Treaty A USA 1979 Signed
Treaty A USA 1985 Ratified
Treaty A France 1990 Signed
Treaty B USA 2000 Signed
Treaty B USA 2001 Ratified

*I want to treat Action as the same and I want a query to send me back the earliest year of a treaty for a country (this is where Dmin comes in)

The new table should look like this:

Treaty A USA 1979 Signed
Treaty A France 1990 Signed
Treaty B USA 2000 Signed

I am having trouble with getting Dmin to work on multiple fields.

[Bob Fitz]

Hi

 
SELECT YourTableName.TreatyName, YourTableName.Country, Min(YourTableName.Year) AS MinOfYear, YourTableName.Action
FROM YourTableName
GROUP BY YourTableName.TreatyName, YourTableName.Country, YourTableName.Action
HAVING (((YourTableName.Action)="Signed"))
ORDER BY Min(YourTableName.Year);

This gives the results you were looking for.

[ohthesilhouettes]

Thanks so much it really helped!