Looking for a Database tool

Eric · 06-19-2006, 01:40 AM

I'm interested in playing with a database tool to generate some OOTP reports. I've dabbled with Access at work but don't have it at work. What do people use at home and how much does it usually cost?

I'm thinking of creating a report that will give you the standings of a specific date during the season. Retrosheet has that for major league baseball. For example, the standings at the end of Aug. 18, 2005 can be found at the bottom of this page: http://www.retrosheet.org/boxesetc/08182005.htm

I'm also thinking of creating a chart that would graph the team's position in the standings during the year.

Steve Kuffrey · 06-19-2006, 01:51 AM

Well the Open Office suite is free and will do all and more of what MS Office will do. You can get it http://www.openoffice.org/

Eric · 06-20-2006, 01:20 AM

Thanks. That worked.

Now I know why it's not possible to view the standings of a pariticular day in a previous year - the data just doesn't exist! Aha!

Comedian2004 · 06-20-2006, 03:05 AM

Quote:

Originally Posted by Eric

Thanks. That worked.

Now I know why it's not possible to view the standings of a pariticular day in a previous year - the data just doesn't exist! Aha!

Does not make it impossible though. You can examine the game results file and tabulate the standings using that.

Eric · 06-20-2006, 11:36 AM

Quote:

Originally Posted by Comedian2004

Does not make it impossible though. You can examine the game results file and tabulate the standings using that.

I checked the game results file and it's only for the present year. It doesn't have it for previous years. I supposed that at the end of the season, I can append the game results file to a different table.

tysok · 06-20-2006, 04:19 PM

Quote:

Originally Posted by Eric

I checked the game results file and it's only for the present year. It doesn't have it for previous years. I supposed that at the end of the season, I can append the game results file to a different table.

I know you can manually... but that's a lot of work. I'm sure someone knows how to automate it... someone, somewhere...

Comedian2004 · 06-20-2006, 04:40 PM

Quote:

Originally Posted by tysok

I know you can manually... but that's a lot of work. I'm sure someone knows how to automate it... someone, somewhere...

This sounds like a job for ANDERSON UTILITIES!

fantom1979 · 06-20-2006, 10:54 PM

Quote:

Originally Posted by Comedian2004

This sounds like a job for ANDERSON UTILITIES!

*Enter Superman Music Here*

06-19-2006, 01:40 AM	#1 (permalink)
Eric All Star Starter Join Date: May 2002 Location: Folsom, CA Posts: 1,121 Thanks: 2 Thanked 8x in 5 posts	Looking for a Database tool I'm interested in playing with a database tool to generate some OOTP reports. I've dabbled with Access at work but don't have it at work. What do people use at home and how much does it usually cost? I'm thinking of creating a report that will give you the standings of a specific date during the season. Retrosheet has that for major league baseball. For example, the standings at the end of Aug. 18, 2005 can be found at the bottom of this page: http://www.retrosheet.org/boxesetc/08182005.htm I'm also thinking of creating a chart that would graph the team's position in the standings during the year.

06-19-2006, 01:51 AM	#2 (permalink)
Steve Kuffrey Administrator Join Date: Jul 1999 Location: S.E. TN - Georgia born and raised Posts: 16,933 Thanks: 14 Thanked 4x in 3 posts	Well the Open Office suite is free and will do all and more of what MS Office will do. You can get it http://www.openoffice.org/ __________________ Steve Kuffrey DABS Atlanta Braves - 2008 Eastern Division Champ DBLC Atlanta Braves - 2011, 2014 East Division Champ, 2012, 2013 NL Wildcard Baseball Maelstrom-Montreal Expos-2013 Tourney winner, 2014 WC Team Sparky's League - Tampa Bay D'Rays No longer an active league.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

06-20-2006, 01:20 AM	#3 (permalink)
Eric All Star Starter Join Date: May 2002 Location: Folsom, CA Posts: 1,121 Thanks: 2 Thanked 8x in 5 posts	Thanks. That worked. Now I know why it's not possible to view the standings of a pariticular day in a previous year - the data just doesn't exist! Aha!