Help! This report was written as a default from the writers of our database software but I'm getting an error that I can't figure out. Here's the formula:
"If (Not IsNull ({tblServiceOrders.TimeReceived})
and Not IsNull ({tblServiceOrders.TimeRequested})) then
ReceivedToRequestedTimeAdjustment := ((ToNumber ({tblServiceOrders.TimeRequested} [12 to 13])) * 60) + ToNumber ({tblServiceOrders.TimeRequested} [15 to 16])
- (((ToNumber ({tblServiceOrders.TimeReceived} [12 to 13])) * 60) + ToNumber ({tblServiceOrders.TimeReceived} [15 to 16]));"
The error is saying "A string or an array of values is requested here." for the first "ToNumber({tblServiceOrders.TimeRequested}"
How do I fix this?