PinkBishop
Sat Nov 01 21:01:36 CST 2003
Kathleen,
Thanks... that worked great. Now it made me think of
something different.
How would I write the query to search ALL the fields with
out adding each field to the code?
Thanks Again!
>-----Original Message-----
>Once you've created the query to search one field, you
can modify the query
>to search more than one field, like this:
>
>"SELECT * FROM tblnames WHERE (firstname
= '::firstname::') OR (middlename
>= '::firstname::') OR (lastname = '::firstname::')"
>
>If you are editing the page in HTML or Code view, make
this change in the
>gray colored code and save your change before you switch
back to Normal or
>Design view.
>
>OR means any of the conditions can be true
>AND means they all have to be true
>
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>
http://www.spiderwebwoman.com/resources/
>
>
>PinkBishop <anonymous@discussions.microsoft.com> wrote:
>> I have done this and I have not gotten the results that
I
>> hoped to.
>>
>> Seems for this to work I need one search box for each
>> field. I want only one search box to search 3 of 20
>> fields for keywords or phases that are input into the
>> search box.
>>
>> What is the difference between and/or when adding
multiple
>> fields?
>>
>> Thanks
>>
>>
>>> -----Original Message-----
>>> Yes. In Step 3 of the wizard, click More Options |
Criteria | Add
>>> Criteria - you can use this to add the number of
search fields that
>>> you need.
>>>
>>> --
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>>
http://www.spiderwebwoman.com/resources/
>>>
>>>
>>> PinkBishop <pinkbishop@hotmail.com> wrote:
>>>> I am trying to create a search form that will query 3
different
>>>> fields. Is this possible with FP DBRW?
>>>
>>>
>>> .
>
>
>.
>