Search results

thanks finally got it... =IIF([text132]=0,"0",[text132]/[text143])

Also tried (IIf([text135]=0,0,[text135]/[text138]))

I have been trying that Iif(text135=0,0, text135/text138) But keep getting an error on the opening of the report, I guess I am not that good at VBA

there is no default setting on a text box and if there is I would still be dividing 0 by 0

http://www.access-programmers.co.uk/forums/showthread.php?t=60629&highlight=active+controls

I have a text boc on a report and the control source is: =([text135]/[text138]) However sometimes text135 and 138 will be 0 How can I change the control to be blank in this instance instead of "#NUM!"? Also I set the decimal places to 2 and still get 6 or 7 decimal places is there another way...

Can you please review the sample db abd let me know why my field "shorttime dup1 is returning and error if the coressponding field are blank and possibly how to fix it? thanks

Thanks for the help and I understand how it will differentiate the dup-1's but how can I calculate the total times of those dup-1's and insert it in a text box on the report?

does "other company" mean any other company name in your code?

Sorry it was to big and would not attach

attached is the database what I am trying to do is get it to run when the report "operator production report" is opened and put the total hours next to the box with total dup-1 jobs worked I put it in the report code but cannot get it to work.

It keeps giving me an error. I have a table with multiple [work types] dup-1, dup-2 etc. I want to pull only the jobs that are Dup-1 then run the Inc calculation on it to get the total time spent on all the jobs.

Help with function code please!!!!! What am I doing wrong here? :confused: Function dup1() IIf ([Report_Operator production report]![Work Type] = "Dup-1") End If dup -1 <= 0 Else Int(Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start...

First I want it to look for all jobs that are dup-1 =Iif[work type]="dup-1" Then I want it to run this calculation on the dup-1 records =Int(Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time]))))*24+DatePart("h",Sum([job completed...

ok now to sound totally dumb, how do I do that?

Is it possible to run two commands in a text box control source? If so how do you split them? I want the first control to limit data based on a type and the second function to calculate data

I am currently using this formula to calculate total time worked that exceeds 24hours: =Int(Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time]))))*24+DatePart("h",Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job...

I am currently using this formula to calculate total time worked that exceeds 24hours: =Int(Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time]))))*24+DatePart("h",Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job...

Still not getting it it is counting all the record and not distinguising between the types of jobs. I will attach part of the db it is the "Operator production report" Password is pbowes. anyone's help is appriciated I cannot upload it it is to large if you would like to view it please email...

Thanks Neileg by changing the code to: COUNT(Iif([job type]=Lit-1,[job type],0)) did the trick and only counted those specific records Thanks again