I created a query with expressions from a table. Now I'm trying to filter out the results of the expression using criteria in the query. I keep getting the dreaded "Data Type Mismatch in Criteria" error.
My expressions in the query are:
Over: IIf([Over Formula]>24,"Yes","No")
Over Formula: (DateDiff("n",[Present],[Discharge]))/60
Present: Format([Present Date] & " " & [Present Time],"mm/dd/yyyy hh:nn:ss")
Discharge: Format([Discharge Date] & " " & [Discharge Time],"mm/dd/yyyy hh:nn:ss")
I either want to have the "Yes" of the Over Expression to be returned only or the >24 of the Over Formula Expression to be returned only.
The Present Date and Present Time and Discharge Date and Discharge Time Fields of the Table are all set at Date/Time in the table.
I've tried multiple criteria's in the criteria expression with the same error message popping up every time.
Are there too many expressions?
Any help would be appreciated.