Query showing #error in field

[mkelly]

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

 

[Jon K]

The #Errors are caused by using CDate() on null values. You can change it to:-

IIf(IsNull([dup1s]) or IsNull([dup1f]),Null,Int([dup1f]-[dup1s]-CDate("0:0:" & DatePart("s",[dup1f]-[dup1s])))*24+DatePart("h",[dup1f]-[dup1s]-CDate("0:0:" & DatePart("s",[dup1f]-[dup1s]))) & Format([dup1f]-[dup1s]-CDate("0:0:" & DatePart("s",[dup1f]-[dup1s])),":nn")) AS [shorttime dup1]