Setting up a baseball database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im keeping Stats for a baseball team, currently im doing this in excel but I
would like to set Access up so that I could do it all in there. Currently I
have to manually add all the numbers whenever I up date it after a game. I
want to be able to have a form where I just put in their at bats, runs, hits
etc after each game and have it automatically add it to the total in a table.
any suggestions on how to do this?
 
I don't think you want to "automatically add it to the total in a table".
Totals are generally calculated in a query or report or form. It is rarely
necessary to store calculated values.

If you really feel you need to, use totals queries to append records to a
cumulative stats table. However, I strongly recommend that you don't.
 
I think your right, I just want to be able to have a form where after each
game I enter in things like At bats, runs, hits etc and have those added to
the player's total number of at bats, runs etc so there is a total number of
at bats runs etc, there a good way to do that?
 
Create a totals query that groups by player and totals the various fields.
You can also create totals in forms or reports.
 
Back
Top