Not sure if this is the correct thread or the General but I'm experiencing the following problem.
I have created a query where Total Time is calculated.
I then want a field in the query where if Total Time is > 24 hours then "Yes" and if not "No"
I have tried this but get #Error as the results:
Over: IIf([Total Time]>24,"Yes","No")
I have tried this but found errors myself in the results (for instance it returns "Yes" for an entry that's Total Time = 8:20):
Over: IIf([Total Time]>"24:00","Yes","No")
Help would be appreciated. This is one of my finals steps for my database.