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.