indexing - Why does search condition fail on MS Access number field that is indexed? -

create table in access field long int. set field indexed (either type). create 1 record value of 1. create query looking records in table value less 5. works. search records value less 5.5. fails.

should reported microsoft? can't find way around this, other removing index.

it's index. expects integer while 5.5 on own seems casted decimal.

so, when setting filter, first convert using function return integer:

int, fix, cint, clng, cbyte, cbool