H
hkgary33 via AccessMonster.com
Dear all,
I've linked a input form(frmSumInput) to a sum query (qrySum) so that when
the user type in the form's text box control(txtInput) and click the search
button, the query will be run with the specific criteria in the textbox. I
would like to set the search the search criteria to be "Find Similar", so
that if user input "*a*bc*" in textbox, then it will be pass in the query to
show those some calculation results concerning those records which that
specific field contains character "a" and "bc". Now, in the SQL view of my
query, I wrote:
SELECT SUM(cost) ...... FROM ...... WHERE .... LIKE [Forms]![frmSumInput]!
[txtInput]
But the problem is that it seems cannot recognize my "WHERE" statements, and
none results shown in the query, how can I do to amend the query so as to
solve the problem? Or is that any problem to create query in this way?
Thanks so much!!!!!
Gary
I've linked a input form(frmSumInput) to a sum query (qrySum) so that when
the user type in the form's text box control(txtInput) and click the search
button, the query will be run with the specific criteria in the textbox. I
would like to set the search the search criteria to be "Find Similar", so
that if user input "*a*bc*" in textbox, then it will be pass in the query to
show those some calculation results concerning those records which that
specific field contains character "a" and "bc". Now, in the SQL view of my
query, I wrote:
SELECT SUM(cost) ...... FROM ...... WHERE .... LIKE [Forms]![frmSumInput]!
[txtInput]
But the problem is that it seems cannot recognize my "WHERE" statements, and
none results shown in the query, how can I do to amend the query so as to
solve the problem? Or is that any problem to create query in this way?
Thanks so much!!!!!
Gary