I'm hoping you can help me figure out what I've done wrong with the criteria
range.

It is:

Age=35; Age<=39; Annual=27,000

What returned was a single record of a person age 41 with an annual of 17,500.

The list range included over 290 records and I know there is at least one
that meets the above criteria.