total per employee

  • Thread starter Thread starter Tia
  • Start date Start date
T

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])))
 
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
 
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
Click to expand...
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
Click to expand...
TOTAL PER EMPLOYEE: CDbl(nz(Sum([ANNUAL LEAVE TAKEN ].[TOTAL DAYS])))- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

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