Like operator oops

[Panchovia]

Hi with the following code you get the last number search Like ("*" & [Search_which_Number ?])

Now if you swipe Like ( & [Search_which_Number ?] "*") you should get the first numbers this code doesn't work

What is the correct code.

 

[dhookom]

What happens if you try:

[Search_which_Number ?] & "*"

Duane
Hook'D on Access
MS Access MVP