|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 17th, 2009, 11:34 AM
posted to microsoft.public.access.forms
|
|||
|
|||
total per employee
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]))) 
|
|
#2
November 17th, 2009, 02:03 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
total per employee
On Tue, 17 Nov 2009 03:34:03 -0800 (PST), Tia
wrote: 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])))
|
|
#3
November 17th, 2009, 02:41 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
total per employee
On Nov 17, 6:03*am, Tom van Stiphout wrote:
On Tue, 17 Nov 2009 03:34:03 -0800 (PST), Tia wrote: 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.
|
|
#4
November 17th, 2009, 06:00 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
total per employee
Tia -
Try this: TOTAL PER EMPLOYEE: CDbl(Sum(nz([ANNUAL LEAVE TAKEN ].[TOTAL DAYS],0))) -- Daryl S "Tia" wrote: 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]))) .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
