Symbol and Text Like query (1 Viewer)

N

nyasa05

New member

Local time

Today, 17:10

Joined

Aug 31, 2015

Messages

11

• Jan 22, 2019

• #1

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

I’m here to help

Staff member

Local time

Today, 14:10

Joined

Oct 29, 2018

Messages

21,454

• Jan 22, 2019

• #2

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

 

N

nyasa05

New member

Local time

Today, 17:10

Joined

Aug 31, 2015

Messages

11

• Jan 22, 2019

• #3

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

 

theDBguy

I’m here to help

Staff member

Local time

Today, 14:10

Joined

Oct 29, 2018

Messages

21,454

• Jan 22, 2019

• #4

nyasa05 said:

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

Click to expand...

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

Code:Copy to clipboard

Like "*[#]Variance*"

 

N

nyasa05

New member

Local time

Today, 17:10

Joined

Aug 31, 2015

Messages

11

• Jan 22, 2019

• #5

You rock. That worked. Thank you.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 14:10

Joined

Oct 29, 2018

Messages

21,454

• Jan 22, 2019

• #6

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