Paramenrter query using '(' and ')'

AccessKurzo

Dazed and Confused
Local time
Today, 04:58
Joined
Jan 5, 2001
Messages
55
I have a string that includes '(' and ')' characters - Access does not seem to like this.

for example, I have a string:Abacavir (Ziagen)__

if I paste it as a criteria, Access changes it to:
Abacavir ("Ziagen")__

I have tried 'Abacavir (Ziagen)' - but with no luck...

Any suggesstions?
 
did you try double quotes? "Abacavir (Ziagen)" should work ok
 
never mind - it was another part of the query :rolleyes:
 

Users who are viewing this thread

Back
Top Bottom