Need help with special characters in field, queries failing.

[eschroll]

Hi all!

One of the fields in an existing Access 2010 db column is in the following format: #-#-###:###

In trying to do a query with the [Enter TMK] criteria, nothing is returned. The idea is for the User to search for a specific TMK, and all of the records associated with it. There may be several records with the same TMK (different dates, actions, etc.).

I can do a "Starts with", only enter the first # and it filters correctly. As soon as I put in a -, it will return nothing.

I have tried formatting the field as a number and as text, with the same result. Help!



I just want the User to put in, say, 2-1-234-007 into the [Enter TMK] query, and have the filter return all records containing that in the TMK column.

Many, many thanks!!!!!

Eric

[eschroll]

Make that example query 2-1-234:007

Typed too fast :/

[burrina]

Have you tried Like "2-1-234:007"

[June7]

Are you using an input mask? Are those values actually saved with the punctuation?

[eschroll]

When I try Like "2-1-234:007" in Find, nothing is returned. When I try it in the Query with the [Search TMK] criteria, it errors with incorrect or too complex.

There is an Input Mask of #\-#\-###:###

Thanks, all!

[June7]

That input mask does not force saving the punctuation. The actual data does not have the hyphens and colon. Try search on 21234007 and see what happens.

If you want to save the punctuation, input mask for a text field:

#\-#\-###:###;0;_

[John_G]

What is the data type of the TMK field? In your screen capture above, the column is right-justified, indicating it is numeric (long integer). If that is the case, you won't be able to store the punctuation in the data at all - you would need a text field.

John