Query for the character - in a field withing a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am fairly new to Access. I need to query for special characters in fields
of a table. I have been successful in querrying for & ^ ( ) ones that HL7
will not take for interfacing. I am trying to query for a - but it will not
work. I type "-" just as I did the above. Is there something different I need
to do to query this character? It is defined as a text field in the table.
Thanks much in advance!
 
This is how I currently have the query that works:Like "*&*" Or Like "*\*" Or
Like "*/*" Or Like "*~*" Or Like "*(*" Or Like "*)*" Or Like "*^*" Or Like
"*[*" Or Like "*]*"
 
I found the answer, it should be "*-*" I dont know why the others dont need
the astrisk?
 
Never mind...Im loosing it today. They are all that way. Way too much to do,
need to slow down and look again.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query Truncating Memo Field at 255 Characters 2
Query field size quandry 2
Split data in field on character return 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
replace characters in table 6
Make table query: [Enter 1] AS Test 1
Use first 3 characters in query 4
Defining Text field sizes in destination Make-Table Query 3

Back
Top