Like query

[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

 

[tiger0268 via AccessMonster.com]

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

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

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