S
shelter
I have looked at all the threads addressing the Replace function, but
none seem to address my problem.
I am running Access 2003. I have a table with a text field which
contains numbers formatted as yy-12345 (I cannot change the field type
as this is part of a proprietary application). I created a query that
allows a user to select a range of these numbers, ie; 06-100 through
06-150. My problem is that this returns all records containing these
numbers, ie; 06-1001, 06-1500, etc. I think the hyphen may be seen by
Access as a wildcard somehow. How can I make the query return the
appropriate range (no wildcards)? Thank you for your time.
none seem to address my problem.
I am running Access 2003. I have a table with a text field which
contains numbers formatted as yy-12345 (I cannot change the field type
as this is part of a proprietary application). I created a query that
allows a user to select a range of these numbers, ie; 06-100 through
06-150. My problem is that this returns all records containing these
numbers, ie; 06-1001, 06-1500, etc. I think the hyphen may be seen by
Access as a wildcard somehow. How can I make the query return the
appropriate range (no wildcards)? Thank you for your time.