Question In Operator

[access_newbie]

Q1
I need help with the In operator. I have a table with a field called Error_Messages which has following values: (Err1), (Err2), (Err3)

I am trying to use the In operator as follows:
In((Err1), (Err2))

I get an error due to the fact that I have brackets () in the field Error_Messages. Can someone help me?

Thanks.

 

[Brianwarnock]

Try In("(Err1)", "(Err2)")

 

[access_newbie]

Does not work. Any other suggestions?

 

[Brianwarnock]

You will need to post your DB, because if you have a field with values (Err1), (Err2), (Err3) then a criteria expression as i posted will work, how do I know well I have just tried it.

Brian