I have a bunch of data that starts with "22P" yet when I type the following into a criteria for queries
It returns no results. Yet if i search for "2P" it shows them all.Code:Instr(1,[field],"22P") > 0
I know you can't tell it to start with 0 because that produces an error but what am I doing wrong?