Lahman Database Simple Question

[TheAnswer1313]

I recently download the lahman database and I had a very easy question i was hoping someone would help me with. Im pretty much new to access but I been playing around with the queries and im getting the hang of it slowly. I can seem to do queries involving single seasons but im having trouble with cumulative totals.

For instance.......say I wanted a list of the top ten all-time leaders in home runs.....how would I go about doing that. As you know the database is broken into years......so im unsure how i would do something cumulative. Thanks for your help

[Ubiquitous]

Quckest way is to query batting. Pick player ID and HR. Then in button menu section you should see the greek letter E hit that and some cells will pop up that say group by. Going into that cell and change the HR to sum. It will total up all the homers for all the playerID's. Now from there you can just switch over to the display or again in the above button section you can tell it to display only the top ten. But make sure to set the cells for HR on descending.

[AstrosFan]

Wow, that's pretty cool. I queried it for AB, H, HR, and K, and calculated BABIP for all hitters with 5000+ ABs through 2005 (the Lahman database won't be updated until November).

The top 25:

FName	LName		BABIP
Ty	Cobb		0.372
Rogers	Hornsby		0.365
Rod	Carew		0.361
Derek	Jeter		0.36
Billy	Hamilton	0.352
Harry	Heilmann	0.351
Bill	Terry		0.35
Ed	Delahanty	0.348
Wade	Boggs		0.348
George	Sisler		0.346
Roberto	Clemente	0.346
Kiki	Cuyler		0.346
Kirby	Puckett		0.345
Tony	Gwynn		0.345
Tris	Speaker		0.345
Dan	Brouthers	0.344
Willie	McGee		0.343
Manny	Ramirez		0.342
Mo	Vaughn		0.342
Jesse	Burkett		0.342
Willie	Keeler		0.34
Lou	Brock		0.34
Edgar	Martinez	0.34
Eddie	Collins		0.34
Babe	Ruth		0.34

And the bottom 25:

FName	LName		BABIP
George	McBride		0.228
Monte	Cross		0.234
Mickey	Doolan		0.244
Wid	Conroy		0.245
Eddie	Miller		0.246
Graig	Nettles		0.248
Germany	Smith		0.249
Del	Crandall	0.251
Ed	Brinkman	0.252
Joe	Pepitone	0.252
Darrell	Evans		0.253
Dave	Kingman		0.256
Roger	Maris		0.257
John	Mayberry	0.257
Rocky	Colavito	0.258
Harmon	Killebrew	0.258
Willie	Jones		0.258
Eddie	Joost		0.259
Mickey	Stanley		0.259
Everett	Scott		0.259
Terry	Turner		0.259
Tommy	Corcoran	0.259
Mark	McGwire		0.26
Andre	Thornton	0.26
Bones	Ely		0.26

This is one of those just for fun things. I'll play around with this kind of thing more in my spare time. Doubt I'll post any more of the numbers though.

[TheAnswer1313]

Thanks. I figured it was something very easy.........guess ill have to play around with it more to get the full hang of it.

[SABR Matt]

I taught myself basic Access manipulation by necessity because I had to use it in the process of calculating PCA ratings...it's fairly straightforward to learn enough to give you some weapons to fight with when answering basic questions...once you get the hang of setting up relationships and doing nested queries...there's a lot you can do.

[TheAnswer1313]

Is access a good program to use......or should I also try programs like mysql?