mkelly
Registered User.
- Local time
- Today, 15:08
- Joined
- Apr 10, 2002
- Messages
- 213
Help with function code please!!!!!
What am I doing wrong here?
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 time]))))*24+DatePart("h",Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time])))) & Format(Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time]))),":nn")
End Function
What am I doing wrong here?

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 time]))))*24+DatePart("h",Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time])))) & Format(Sum([job completed time]-[job start time]-CDate("0:0:" & DatePart("s",[job completed time]-[job start time]))),":nn")
End Function