I have a table in my database that lists different documents, and each document has an assigned 8-10 digit document number. Each document number is unique, however the basic structure of the number is about the same. For example, one number might be 546-RES-09-092 and another might be 546-SS-08-023. So, to make it easier on the person entering this data into the database, I set up an input mask that corresponds with the number structure.
The problem I'm having, involves a query that I set up to locate specific documents. Due to the input mask some of the document numbers have spaces where there isn't a character assigned to the space. So, 546-SS-08-023 comes out as 546- SS-08-023. I need a query that will find the document number regardless of the space or not because the average user will not know to input the spaces. Is this possible?
Thanks
The problem I'm having, involves a query that I set up to locate specific documents. Due to the input mask some of the document numbers have spaces where there isn't a character assigned to the space. So, 546-SS-08-023 comes out as 546- SS-08-023. I need a query that will find the document number regardless of the space or not because the average user will not know to input the spaces. Is this possible?
Thanks