Calculated field using Expression Builder

[Pyeman]

I'm new to Access. I am trying to develop a golf scoring program whereby I can track participants earnings and report those earnings for each discrete tournament. I created a table with each participants name and additional fields with additional data. In addition I created individual fields for all the potential money prizes (such as low gross, KP, Skin, etc) a participant could win in any given tournament. I have entered data into these fields. I want a final field that adds these money fields together to generate a total for each individual player. I tried creating a calculated field in Expression Builder called "Total earnings" by selecting those relevant fields. It successfully generated a total for the first player but not the others. What am I doing wrong??

[June7]

Most likely one or more fields in the expression is Null. Arithmetic with Null results in Null. Either normalize table structure so each prize won is a record in a related dependent table or handle possibility of Null with

IIf(IsNull(KP),0,KP) + ...

or

Nz(Low) + Nz(KP) + Nz(Skin)

Unfortunately, Nz() is not available to table calculated field. Do this calc in query or textbox.

[CJ_London]

you have taken an excel approach to your database which is not the way for databases. And using calculated fields in tables is a bad idea, just because you can doesn't mean you should

from your brief description I can see the need of at least 4 tables, possibly more - participants, tournaments, prizes linked to tournaments and a linking table between participants and tournament prizes

Not trying to put you off, but if you want to do it the way you have described, suggest use Excel which works with those methods

As regards your question, would need to see what you have used in your calculation, if it works for one player it should work for all of them. Best guess would be your data contains nulls so you would need to use an iif statement around an isnull function

....+iif(isnull(myfield),0,myfield)+.....

a properly constructed db would do this automatically