use of a period

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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

Like "*" & [Enter the value] & "*"
Will prompt for the value.
 
along those same lines, is there a way to use a period inside the [] brackets
when promting a user for criteria in a query?

fredg said:
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.
Click to expand...

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

Like "*" & [Enter the value] & "*"
Will prompt for the value.
Click to expand...
 
Back
Top