I am trying to setup access to score a golf tournament.
I have the tables setup and forms to enter the data.
I have everything in one big table.
I have fields set up for storing each golfers total score.
How do I get access to add up the scores and put them in that
field.

Thanks
John

Generally, you don't want to store calculated fields in a database
(there are some exceptions). In this case, it appears that you would
be better served by calculating the field as you need it. Put the
calculation in a query, and referece that query from the forms and/or
reports. better to have only one query with the calculation, if
possible. this way, if you need to change it for some reason, you
only have to change it in one place.

hope that helps. tom


TiredOldSkier (AT) yahoo (DOT) com (JohnMc) wrote in message news:<20fb9c66.0308071148.20318798 (AT) posting (DOT) google.com>...