Search Form on DBRW

[PinkBishop]

I am trying to create a search form that will query 3 different
fields. Is this possible with FP DBRW?

 

[Kathleen Anderson [MVP- FP]]

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.

 

[PinkBishop]

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

 

[Kathleen Anderson [MVP- FP]]

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

 

[PinkBishop]

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