in my first post, I didn't notice that the field you wanted to query is a
description field. I'm assuming that this means that the field contains a lot
of text, and you want to be able to search for those records that contain one
or more of the search words that you want to type into the inputbox that is
associated with a parameter query.
If this is the case, I have not been able to find a way to do so. What I
generally do is create a form (frm_Filter) that includes a textbox where I
enter one or more words to search for. Then, when the user clicks a command
button, I parse the text, build the filter, and apply it to a form or query.
If you want more details on this process, post back. It would also be
helpful to know what you are doing with this query. Are you using it in a
form, report, as the source for a control?
--
HTH
Dale
email address is invalid
Please reply to newsgroup only.
jjhinton said:
I am a new user to Access. I'm not sure what this means. I currently have
the following line in the 'criteria' line of the query. Is there a way to do
this on the 'criteria' line? Thanks.
Like "*" & [Enter characters to search for in the Main Description:] & "*"
Dale Fye said:
My guess is that your current query looks something like:
SELECT * FROM yourTable
WHERE [SomeFieldName] = [Enter search criteria]
which would give you a pop-up box as you indicate
Another way to do this, to accomplish what you want is
SELECT * FROM yourTabel
WHERE Instr([Enter Search Criteria], [SomeFieldName]) > 0
--
HTH
Dale
email address is invalid
Please reply to newsgroup only.
jjhinton said:
I have a query in which the user is prompted to enter a value. The report
then prints all records that contain that value in a field named “Main
Descriptionâ€.
Is it possible for the user to enter more than one value to search on within
the field “Main Description�
Example: Can the user enter “Snowden†and then “Kendall†to print a report
that contains all records containing either “Snowden†or “Kendall†in the
Main Description?
