Parameter query will only recognize numbers in the field

P

paulpenta

My query is opened based on criteria contained in the field "Form Control
Number".

These numbers are a combination of letters and numbers (e.g. DD0034). In the
criteria box, I've typed [Enter Form Control Number].

When the dialog box appears, if I enter DD0034, I get nothing. If I just
enter 0034, I get all the records I'm for which I am looking.

Why?

THanks
 
B

Brian

Does the criteria in the query use "Like" before your [Enter Form Control
Number]? If not, then it is finding an exact match based on just the numbers.

Does the table actually show "DD0034" in that record? Is it possible that
the "DD" is not actually stored in the table, but is instead inserted on a
form just to show the user the two-letter prefix? Or is it possible that the
prefix is stored in a separate field in the table from the numbers?
 
Top