use of a period

[Guest]

I am trying to set up a query that will find things like ID code V48.3.
However, I find that I can not enter the period of the 48.3 in the perameter
text. Is there a way around this?

Thanks in advance and have a nice day.

 

[fredg]

I am trying to set up a query that will find things like ID code V48.3.
However, I find that I can not enter the period of the 48.3 in the perameter
text. Is there a way around this?

Thanks in advance and have a nice day.

Like "*.*"
works for me to find any value with a period.

Like "*" & [Enter the value] & "*"
Will prompt for the value.

 

[Guest]

along those same lines, is there a way to use a period inside the [] brackets
when promting a user for criteria in a query?

I am trying to set up a query that will find things like ID code V48.3.
However, I find that I can not enter the period of the 48.3 in the perameter
text. Is there a way around this?

Thanks in advance and have a nice day.

Like "*.*"
works for me to find any value with a period.

Like "*" & [Enter the value] & "*"
Will prompt for the value.