I have a table with a dateofbirth field. I have a query which has a calculated field "Age: Int(DateDiff("d", DOB, Date)/365.25)".
This works fine.
I then add criteria to limit the age to a specific range like "BETWEEN 21 AND 50".
Strange thing is, it works fine, but after about 1.5 seconds an error message "Data type mismatch in criteria expression" appears.
I am at a loss.
This works fine.
I then add criteria to limit the age to a specific range like "BETWEEN 21 AND 50".
Strange thing is, it works fine, but after about 1.5 seconds an error message "Data type mismatch in criteria expression" appears.
I am at a loss.