I want to return a Yes/No for anything greater than 24 hours. Is this possible? If so how would I write it?
I have the following Expression in a query:
Over: IIf([Total Time]>"23:59","Yes","No")
Total Time: DateDiff("n",[Present],[Discharge])\60 & Format(DateDiff("n",[Present],[Discharge]) Mod 60,"\:00")
Am I doing something wrong? I found Errors in the [Over] Expression. For instance it reads "Yes" for a Record that is returned as 8 hours and 20 minutes. The [Total Time] works great I just can't figure out the [Over] Expression.