If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SQL Query Syntax
I cant figure this out if I use Like in the below statement it works
grear no problem. GCriteria = Forms![frmSearchByJob]![cboSearchField].Value & " LIKE '*" & Forms![frmSearchByJob]![txtSearchString] & "*'" If use use the = sign i get an error in the statement I get no records. GCriteria = Forms![frmSearchByJob]![cboSearchField] = Forms![frmSearchByJob]![txtSearchString] Is there something wrong with the sytax? Any help would be appreciated |
#2
|
|||
|
|||
SQL Query Syntax
I got it Thanks On Thu, 14 Jan 2010 23:15:07 -0500, Little Penny wrote: I cant figure this out if I use Like in the below statement it works grear no problem. GCriteria = Forms![frmSearchByJob]![cboSearchField].Value & " LIKE '*" & Forms![frmSearchByJob]![txtSearchString] & "*'" If use use the = sign i get an error in the statement I get no records. GCriteria = Forms![frmSearchByJob]![cboSearchField] = Forms![frmSearchByJob]![txtSearchString] Is there something wrong with the sytax? Any help would be appreciated |
Thread Tools | |
Display Modes | |
|
|