I have a table with a field that contains both 6 and 9 digit numbers. All 6 digit numbers have 3 spaces after them. I'm not able to change the structure of this table.
If I query directly to the table and enter a 6-digit search criteria, I get results. However, if I program a field on a form to query the same value, I get zero results.
Any ideas? Let me know what other kind of information I can provide. I'm stumped!