Thread: Calculate Total Hours Worked For Week Based On Check Boxes.
View Single Post
  #9  
Old August 29th, 2008, 11:59 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
  
Posts: 18,261
Default Calculate Total Hours Worked For Week Based On Check Boxes.
On Fri, 29 Aug 2008 14:25:00 -0700, Pablito
wrote:

Hi Jeff,

Yes, I tried adding the check boxes, but I'm not sure I'm using the right
expression. I tried: sum(IIF([sun]= -1 or [mon]= -1 or [tue]= -1 or [wed]=
-1 or [thur]= -1 or [fri]= -1 or [sat]= -1)). No luck so fare.


It's not that hard. Try

-Sum([Sun] + [Mon] + [Tue] + [Wed] + [Thu] + [Fri] + [Sat])
--

John W. Vinson [MVP]