add values from four columns in query ms access 2003

J

Jeroen

hello, I want to add (som) values from four different columns to have a total
score from four columns. My columns are person, kwartaal 1, kwartaal 2,
kwartaal 3, kwartaal 4. I want the total score from kwartaal 1,2,3,4 together
of each person.
Somehow I can't manage it. Can you help me ?
 
S

SteveM

Create a field in your query like this:

TotalScore: Nz(kwartaal 1,0) + Nz(kwartaal 2,0) + Nz(kwartaal 3,0) +
Nz(kwartaal 4,0)

The Nz() function will take care of any that may be Null.

Steve
 
J

Jeroen

Thanks for the answer. Has this to be done in a selection query ? I don't
know how to do it. I have to choose a field name Naam, Kwartaal 1, Kwartaal
2, Kwartaal 3 or Kwartaal 4, I have chosen Naam, then Expression and filled
in like below, but that must be fault. I don't know how to make a new field
in the query which isn't made of the fields Naam, Kwartaal 1, Kwartaal 2,
Kwartaal 3 or Kwartaal 4. Can you help me ?
 
Top