Finding data based on earliest dates

[baseball]

I have a database of scores for all baseball games played from 1900 through 2000, with data in the following form:

A------- B-- C--- D----- E-----
YrMoDayID HLg Home VScore HScore
19000419 NL BSN 19 17
19000419 NL CIN 13 10
19000421 NL BRO 2 5
19000421 NL CIN 3 4
19000422 NL CIN 6 7
[...]
20000930 NL HOU 6 7
20001001 NL ARI 11 4
20001001 NL ATL 10 5
20001001 NL FLO 5 7
20001001 NL HOU 1 6

The YrMoDayID is not unique, and is simply a concatencation of the Year, Month, and Day a game was played. Year goes from 1900 to 2000 and Month from 03 to 10.
HLg is the League of the Home team, and can be AL, FL, or NL.
Home is a three-letter team identifier (e.g., BSN=Boston). Not every team played in every year.
VScore and HScore represent the Visiting team's score and the Home team' sscore, respectively.

I need to determine earliest date for every year for each team, and subsequently determine the team's won-lost record based on its opening day games.

Any suggestions as to how I can accomplish this?

[Tom Schreiner]

Hi
Would not be difficult using a macro.
If no one offers any help, send me your workbook.
TsTom@hotmail.com
Tom

[baseball]

Tom, the workbook is very big. I assume that a subset of the data would be adequate?

[Chris Davison]

Baseball,

if this is public domain file, may I have a copy of the database ?

*avid Red Sox fan here*

thanks
Chris

novulari@hotmail.com

[baseball]

On 2002-04-02 12:12, Chris Davison wrote:
Baseball,

if this is public domain file, may I have a copy of the database ?

*avid Red Sox fan here*

thanks
Chris

novulari@hotmail.com

Chris,

Unfortunately this database is not in the public domain; however, there is a public source for looking up game scores from 1900 to 2000, and which includes box scores from 1978 on--Project Retrosheet at http://www.retrosheet.org
under Boxscores, Narratives, Other Goodies.

Also a Red Sox fan,
Cliff

[Chris Davison]

fantastic.... cheers

I'll be over again before they tear down Fenway