Like query

  • Thread starter Thread starter P-Bro
  • Start date Start date
P

P-Bro

Hi

I would like to create a query based on the input from the user
[prompt].
the form of the records is 123-01
I want the query to match the two digits after the -, so that all
records that match -01 are returned, how do I do this in a query using
a []prompt.

thanks

P-Bro
 
P-Bro said:
Hi

I would like to create a query based on the input from the user
[prompt].
the form of the records is 123-01
I want the query to match the two digits after the -, so that all
records that match -01 are returned, how do I do this in a query using
a []prompt.

thanks

P-Bro
Click to expand...

I am not sure what you are actually trying to do, but try the following in
the criteria field:

Like ["verbiage for prompt"]& "*-01"
 
Back
Top