I have 2 dates and I am subtracting them from each other using Result:DateDiff(“d”,date1,date2). The function appears to work correctly and sort in correct numerical order, however when I run another query asking it to sort the results into tiers I get a “data type mismatch in criteria expression”
I am sorting by bringing “result” in the field twice setting the Total to “group by” for one and “where” for the other. and under Criteria, i leave the “group by” blank and the “where” to >1.
Please help me sort and find my error.
Thanks
