Re: search two fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Did you try John's solution? If you did as he said and entered the exact same prompt in the two rows, you will be asked only once. If you are asked twice, then you did not enter the exact same prompt.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


Striker wrote:
yes, but I was trying to avoid having the user type the same thing twice.

"John W. Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:36upf45142clboctmm6c6f0kdeued1kbgr@xxxxxxxxxx
On Mon, 20 Oct 2008 13:32:58 -0700, "Striker" <striker3070@xxxxxxxxx> wrote:

have a table that may contain the information I want to find in one of two
fields. Either the history, or the notes field. So in the query I can
enter a search criteria in the notes field as follows Like "*" & [Enter
Search String] & "*"

Is it possible to make the history field equal what the user inputs in the
notes search box, currently they are entering the same information twice
once for each field before the query runs.

Sure; just use exactly the same criterion on both fields. Put the expression
on *two separate rows* of the query grid so that it uses OR logic (returning
the record if the value exists in either one of the fields).
--

John W. Vinson [MVP]


.

Relevant Pages

  • Re: Ignoring Layout Save Dialog box
    ... but the prompt to save the ... query remains after the form has closed. ... resolve this. ... John W. Vinson ...
    (microsoft.public.access.queries)
  • Re: Comparing Two Tables, show matching data
    ... >John: THANK YOU... ... But how can I get it to find EXACT? ... Could you post the SQL view of your query, ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Great SWT Program
    ... query in a few tools. ... I said the / prompt comes up blank. ... arrows, delete, and cancels if you hit esc. ... a command history I had had occasion to use for months wishing it had ...
    (comp.lang.java.programmer)
  • Re: Error Messages
    ... not he wants to run a delete query. ... To avoid the confirmation prompt, ... or use the Execute method of either the Database ... This table contains a record with the initials of each user that is logged ...
    (microsoft.public.access.setupconfig)
  • Re: Closing an Empty Form
    ... Just as an experiment, can you temporarily alter the query by removing the three criteria that reference the main form, i.e. ... I don't know for sure that the system would prompt for all 3 of the combo-box fields because as you noted, the system crashes after I cancel the first prompt. ... I'm using WinXP and I also did a system restore at one point when I was loading programs onto the new computer. ...
    (microsoft.public.access.queries)