total per employee

[Tia]

Hi

i am trying to get the total taken leave taken by employee i have use
this expression, but it is giving me 0 and the total should be 4

TOTAL PER EMPLOYEE: CDbl(nz(Sum([ANNUAL LEAVE TAKEN ].[TOTAL DAYS])))

 

[Tom van Stiphout]

On Tue, 17 Nov 2009 03:34:03 -0800 (PST), Tia

I noticed in your previous post that the [Total Days] column was
empty. The sum of a bunch of nulls is null, and CDbl(Nz()) converts
that to 0.

-Tom.
Microsoft Access MVP

 

[Tia]

On Tue, 17 Nov 2009 03:34:03 -0800 (PST), Tia


I noticed in your previous post that the [Total Days] column was
empty. The sum of a bunch of nulls is null, and CDbl(Nz()) converts
that to 0.

-Tom.
Microsoft Access MVP

Hi

i am trying to get the total taken leave taken by employee i have use
this expression, but it is giving me 0 and the total should be 4

TOTAL PER EMPLOYEE: CDbl(nz(Sum([ANNUAL LEAVE TAKEN ].[TOTAL DAYS])))- Hide quoted text -

- Show quoted text -

no it is not emplty, i already have it calculated, but what i need is
the calculate total annual by employee.

 

[Daryl S]

Tia -

Try this:

TOTAL PER EMPLOYEE: CDbl(Sum(nz([ANNUAL LEAVE TAKEN ].[TOTAL DAYS],0)))