You can't put that criteria in the same query as the calculation. You'll have to take the results of that query and feed it into a second query, and you could put the criteria there.

I actually have a video on this topic coming out pretty soon because it's a common mistake.

I am still doing something wrong. Created second query based on query calculating exact age. Couldn't figure out the proper way to add criteria to avoid data type mismatch error

Your criteria was correct in the first screenshot. Do it like that in the second Query.

Could be due to Null values in the table. See Another Query Fails.

There are no null values. I created a 2nd query based on 1st query. 2nd query properly returns 0's and -1's. How do I writer criteria in 2nd query to display on records with 0's? I need to do same thing with records returning -1's. I want a list of records for under 65 and one for over 65.

Just set your criteria to whatever you want to see.

I created a query using your exact age function. Works perfectly I then created a second query based on the first query to identify records where age was greater than or equal to 65 or less than 65. Works perfectly it returns zeros and minus ones. For I then create a query based on the second query to select only records with zeros, I get a data type mismatch error. I don't know how to fix that. What is the data type being returned that yields zeros and minus one. Please show me how to ride a criterion that will select only the zeros and another one that will select only the minus ones. I spent three days going in circles and beating my head against the wall. I've done my due diligence. I'm waving a white flag. Please help me figure out this very simple problem.

What is being returned are Boolean values (True/False).

How do I use the Boolean value False in a criteria to show only those records match False? That is what I don't know.

test for either "True" or "False" as needed.

I have tried the following in the Criteria row: -1, 0, True, False. I have tried with and without quotation marks. There is something very basic I am overlooking. Everything I have tried has generated the error data type mismatch. Please help.

Show us what the data look like.

Could be the problem I referenced in the video above... You may need to dump the data into a temp table.