Symbol and Text Like query

[nyasa05]

Hello,
I'd like to query #Variance in an access database. I have the Like'*[#]*' but I can't seem to incorporate the variance to that. Can someone please help me with that?

Thanks

 

[theDBguy]

Hi. What do you mean by #Variance. Is "Variance" supposed to be a number or something?

 

[nyasa05]

No, I am querying a comments field so I want records that include #Variance in the comments field.

 

[theDBguy]

No, I am querying a comments field so I want records that include #Variance in the comments field.

Do you mean "#Variance" is a literal value? If so, have you tried something like:

Like "*[#]Variance*"

 

[nyasa05]

You rock. That worked. Thank you.

 

[theDBguy]

Hi. You're welcome. Glad to hear it worked. Good luck with your project.