Feb 21, 2015 #1 Panchovia Programmer May 6, 2010 48 CW 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.
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.
Feb 21, 2015 #2 dhookom Programmer Jun 24, 2003 22,519 US What happens if you try: SQL: [Search_which_Number ?] & "*" Duane Hook'D on Access MS Access MVP Upvote 0 Downvote