Query for the character - in a field withing a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Monica - 06 Apr 2006 18:12 GMT

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!

Reply to this Message

Monica - 06 Apr 2006 18:15 GMT

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 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!

Reply to this Message

Monica - 06 Apr 2006 18:23 GMT

I found the answer, it should be "*-*" I dont know why the others dont need
the astrisk?

Reply to this Message

Monica - 06 Apr 2006 18:25 GMT

Never mind...Im loosing it today. They are all that way. Way too much to do,
need to slow down and look again.

Reply to this Message