Parameter query

[jake7363]

Hi,
My database includes a JobNo field that is masked to appear as "06-01-0234". I am trying to set up a parameter query that allows me to just search for the last four numbers.

I am using
LIKE [Find] & "*"
then enter "0234", it does not pull up the record.

If I use the entire text of "06-01-0234" it will pull up the record.

What am I missing?

Thanks in advance,
Jake

 

[hartwell]

Try Like "*" & Right([FIND],4)

 

[r937]

try Right(Jobno,4) = [Find]

r937.com | rudy.ca

 

[jake7363]

Thanks to both! Much appreciated..