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 ?

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
--
Steve McGuire
MCSD, MCAD, MCP


"Jeroen" wrote:

> 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 ?

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 ?

"SteveM" wrote:

> 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
> --
> Steve McGuire
> MCSD, MCAD, MCP
>
>
> "Jeroen" wrote:
>
> > 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 ?