A
Andrea
I have a contract database. One table includes a field for contract
provisions. I have created a query that allows you to search by different
contract criteria. However, I would like to be able to seach by keyword
found in the contract provision field. For example, the user would open a
form, type in the keyword, which would prompt the query to search by such
keyword and pull up all the contracts and contract provisions that include
that keyword.
I am not sure how to format this in the criteria box. The keyword would be
entered into the following [forms]![frmContracts]![ThisValue1]. Thus, my
thought is that the criteria field in the query should read something along
the lines of: Like"[forms]![frmContracts]![ThisValue1]". But this is not
working because I do not think there is enough specified to use the like
function. I am not sure if I should use where or having.
Thanks!
provisions. I have created a query that allows you to search by different
contract criteria. However, I would like to be able to seach by keyword
found in the contract provision field. For example, the user would open a
form, type in the keyword, which would prompt the query to search by such
keyword and pull up all the contracts and contract provisions that include
that keyword.
I am not sure how to format this in the criteria box. The keyword would be
entered into the following [forms]![frmContracts]![ThisValue1]. Thus, my
thought is that the criteria field in the query should read something along
the lines of: Like"[forms]![frmContracts]![ThisValue1]". But this is not
working because I do not think there is enough specified to use the like
function. I am not sure if I should use where or having.
Thanks!