I have a table with a drop down field in it. The info you select is stored in the field named Clock #. It works fine. When I try to run a query on this table using this field, I can only get it to run if I show all the records. When I specify a particular Clock #, I get nothing. The field is 5 characters long and the first Clock # is 00001 going up to 05000. The Clock #s are coming from a linked table. I have verified the design of the fields in both tables. We have tried every kind of wild card, etc. Nothing seems to work.
HELP
HELP
