Search results

thank you for responsding Plog, I appreciate it :) I think got it to work .. I change the sum iif statement to Hours Worked: Sum(IIf(Nz([StandardTime]=0)=0,0,[Sumoftime]/60*100)+([StandardTime]*[Sumoforders]/60*100)) this gives me the results I was looking for....

Thank you ! ...this works great ... and the weekending is Sunday

Hello, I have the following Sum IIf test: Sum(IIf(Nz([StandardTime]=0),[SumOfTime]/60*100)+([StandardTime]*[SumOfOrders]/60*100)) the first part calculates .... and is fine Sum(IIf(Nz([StandardTime]=0),[SumOfTime]/60*100) the second part does nothing ...

Is it possible to get a list of all weekending dates between 2 dates in a query? for example, 1/1/2012 and 12/31/2012 if so, how ? I've been able to get the weekending date based on 1 date but between 2 dates thank you in advance

Good morning, 1st off my apologizes for the delay ... we had some things blow up at work and I have been busy with that ... I will be playing with this sample db later on today ... Just wanted to provide an update ... take care

Just wondering .... can you provide a sample of your Db? ...before I start creating one :)

Sounds like you need a Total's query ... with a count of issueId's grouped by IAVerification Question ... do you wan to display the total number of "issues" based on "IAVerification" so, the example would be .... CountofIssueId's IAVerification 10 Not Yet Verified...

I just went through the same pain :) But with the help of boblarson I was able to figure it out ... the link below might help .... http://www.access-programmers.co.uk/forums/showthread.php?t=207729

Hell yes ! ! ! !:D:D:D:D:D Got it working ! I had to break up the formula into 3 parts/calculations 1st - Working Time 2nd - Non Working Time 3rd - Utilization Here is the code ...in SQL View SELECT Sum(IIf(Nz([PPnRPriorityAreaName]="Simplify &...

I think I know what the issue is .... How would I subtract the amount time in [PPnRPriorityAreaName]="Admin - Non Working" from 34.15 and then sum ... The idea is ...if an employee has planned to be away 1 day (6.83) hours and the remaining time they are working (27.32 Hrs)..their planned...

Hi Bob, Okay ...so i had to make some changes to it Now this formula is Sum(IIf(Nz([PPnRPriorityAreaName]="Simplify & Optimize",0)+Nz([PPnRPriorityAreaName]="Customer Experience",0)+Nz([PPnRPriorityAreaName]="Financial",0)+Nz([PPnRPriorityAreaName]="Admin -...

Just an Fyi .... based on your earlier post explaining the break of my formula ...I just tried the following and got 702% :confused: fun times .... PlannedUtilization: Sum(IIf([SumOfPlannedHours]=0,0,IIf([PPnRPriorityAreaName]="Simplify & Optimize" Or [PPnRPriorityAreaName]="Customer...

It should be .... [Simplify & Optimize] + [Customer Experience] + [Financial] + [Admin - Working] - [Admin - Non Working] = 0

Actually its five diff values ..... Simplify & Optimize Customer Experience Financial Admin - Working Admin - Non Working (not included in % utlization)

Hi again Bob :) Basically ... this is what I require ... If the sum of ([SumOfPlannedHours] in ([PPnRPriorityAreaName]="Simplify & Optimize" And "Customer Experience" And "Financial" And "Admin - Working" is equal to 0 then 0% if not ...then sum ([SumOfPlannedHours] In...

Re: Sum Iif Query Just tried the following ..and got the same 20% result .... Its obviously not the looking at the value i want incorporate in to the formula PlannedUtilization: Sum(NZ(IIf([SumOfPlannedHours],IIf([PPnRPriorityAreaName]="Simplify & Optimize" And "Customer Experience" And...

Okay .... So I have been playing around with and I have gotten to this point This formula works: PlannedUtilization: Sum(IIf([SumOfPlannedHours]=0,"Fixed",IIf([PPnRPriorityAreaName]="Simplify & Optimize" And "Customer Experience" And "Financial" And "Admin - Working", -...

Hello, I've battling with this query for awhile now and I think I got it to work but need confirmation that is doing what I want it to do :) Query is SELECT Sum(IIf([SumOfPlannedHours]=0,"%",([SumOfPlannedHours]/34.15*1)-([SumofPlannedHours] And [PPnRPriorityAreaName]="Admin - Working")))...

Just tried using the following and now I'm getting a Run time error 94 Invalid use of Null Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Result As Double If (Me.PlannedHours) <= 0 Or IsNull(Me.SubActivityDetails) Then MsgBox ("You must enter planned hours and provide a...

Just adding a screenshot so ppl don't think I'm crazy .... All I want is for the code to do .... check if the person over or under and allocated time (34.15) for the current weekending and display the appropriate message .... thats all .... why it is not working is beyond me...