View Single Post
Old 08-23-2006, 10:45 AM   #1
silvam14
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Dedham, MA
Posts: 10,156
More MS Access fun with the .CSV dump! Career All Star Stats!

Just a little something I produced in MS access using the csv files.

I realized that the game by game stats tables get truncated and re-populated with each season which is a downer. (It must be to limit size) So, in order to get the career stats. I import the new csv the day after each all star game, and then I have an append query I use to populate two tables which I created (Batting and pitching stats) I then run my report off of those.

Anyway, check it out
Attached Images
File Type: pdf All Star Batting.pdf (30.5 KB, 90 views)
File Type: pdf All Star Pitching.pdf (18.3 KB, 54 views)
__________________
Senior "Nancy Boy" of the OOTP Boards
_______________________________________________
silvam14 is online now   Reply With Quote