Problem with Queries

hawevine

New member
Local time
Today, 02:59
Joined
Apr 25, 2014
Messages
3
I need help with this criteria please. The search is under the phone numbers. The result supposed to grab the area code whatever the user selection is. I'm using this one: Like "*2" & [Forms]![frmEmployees]![txtEmployees] & "*" Or Like "*1" this one only grabs the 2s and not the ones. supposed to grab ones if the user select one, and two if the user select 2.

Please help

Victor
 
The code will translate as, say you enter 03 as the form input, then all the following.
012035689
203569988
000000001
1
012541

Is this what you want? Explain is simple terms what is that you are after, we might be able to give you a right solution.
 
When the user open the form and typed 1 all the area code of the phone numbers that begins with 1 will be retrieved. If the user typed 2 will list the area code that begins with 2.

Thank You
 

Users who are viewing this thread

Back
Top Bottom