hi, all
Can anyone tell me what is wrong with this:
strQry = "select * from ticket where " + _
"[record date] <= #" & date1 & "#" + _
"and [Flight NO] like ' ' " & text1 & " '* ' "
Thank you in advance.
Printable View
hi, all
Can anyone tell me what is wrong with this:
strQry = "select * from ticket where " + _
"[record date] <= #" & date1 & "#" + _
"and [Flight NO] like ' ' " & text1 & " '* ' "
Thank you in advance.
try this:
strQry = "select * from ticket where " + _
"[record date] <= #" & date1 & "#" + _
"and [Flight NO] like '" & text1 & "%'"
Thank you ,digisenze.
It worked!