Hello: Not sure how to build this expression. I have 2 fields; [TimeofDelivery] and [ReturnTime] in a query running from a table [Truck Runs]!
If either of the two times fall between <8 am and >4:30 pm, I want those records to show.
I have tried the expression:
I get the error "The expression you entered has a function containing the wrong number of arguments"Code:=IIf([Truck Runs]![TimeofDelivery] <#8:00:00 AM# Or >#4:30:00 PM# OR [Truck Runs]![ReturnTime] <#8:00:00 AM# Or >#4:30:00 PM#)
Am I close, or way off?
Thanks for any help!