My search form has 5 fields (all drop-down lists) that are all
empty/blank to start with ie. the first option of each list is
<option></option> in the HTML. The user can select data from any of the 5
fields. Some fields may be left unfilled when the form is submitted to the
DBRW.
I am using the And comparison for each field - so, as an example, if the
user chooses an option from list 1 and an option from list 4, I would like
only the records that match and are common to both lists returned for
viewing.

My problem is that the fields that are left untouched by the user are being
queried along with the filled fields (which is the way it should work :-) )
I would like them to be ignored. Empty fields should not influence the query
at all.

How can I achieve this? Apologies for the nonDB speak. Quite raw at all of
this, but learning alot!

Mart

Hi Martin:
This article How to add an All Values item to a database query by using the
FrontPage 2003 Database Results Wizard
http://support.microsoft.com:80/kb/825453 might help. If the user doesn't
make a selection, it should use the All Values as the default.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


"Martin Stabrey" <(E-Mail Removed)> wrote in message
news:2228AE82-93F8-4E15-98DC-(E-Mail Removed)...
> My search form has 5 fields (all drop-down lists) that are all
> empty/blank to start with ie. the first option of each list is
> <option></option> in the HTML. The user can select data from any of the 5
> fields. Some fields may be left unfilled when the form is submitted to the
> DBRW.
> I am using the And comparison for each field - so, as an example, if the
> user chooses an option from list 1 and an option from list 4, I would like
> only the records that match and are common to both lists returned for
> viewing.
>
> My problem is that the fields that are left untouched by the user are
> being
> queried along with the filled fields (which is the way it should work
> :-) )
> I would like them to be ignored. Empty fields should not influence the
> query
> at all.
>
> How can I achieve this? Apologies for the nonDB speak. Quite raw at all of
> this, but learning alot!
>
> Mart
>
>

Hi Kathleen

Gee, you've certainly been a wealth of information! Thanks again for all
your help.

Unfortuantely, the "All Values" wildcard does exactly opposite of what I
want ie. I am needing to exclude a field from a query if no selection is
made.

I suppose what I need is a sort of "No Values" wildcard :-)

Thanks again.

Martin

"Kathleen Anderson" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Martin:
> This article How to add an All Values item to a database query by using
> the FrontPage 2003 Database Results Wizard
> http://support.microsoft.com:80/kb/825453 might help. If the user doesn't
> make a selection, it should use the All Values as the default.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> FrontPage Resources: http://www.spiderwebwoman.com/resources/
> Please reply to the newsgroup for the benefit of others
>
>
> "Martin Stabrey" <(E-Mail Removed)> wrote in message
> news:2228AE82-93F8-4E15-98DC-(E-Mail Removed)...
>> My search form has 5 fields (all drop-down lists) that are all
>> empty/blank to start with ie. the first option of each list is
>> <option></option> in the HTML. The user can select data from any of the 5
>> fields. Some fields may be left unfilled when the form is submitted to
>> the
>> DBRW.
>> I am using the And comparison for each field - so, as an example, if the
>> user chooses an option from list 1 and an option from list 4, I would
>> like
>> only the records that match and are common to both lists returned for
>> viewing.
>>
>> My problem is that the fields that are left untouched by the user are
>> being
>> queried along with the filled fields (which is the way it should work
>> :-) )
>> I would like them to be ignored. Empty fields should not influence the
>> query
>> at all.
>>
>> How can I achieve this? Apologies for the nonDB speak. Quite raw at all
>> of
>> this, but learning alot!
>>
>> Mart
>>
>>
>
>

Hi Martin:
I think if you think about, it would accomplish the same thing. Looking for
"All Values" of a field would give you the same results as not using the
field in your query. At least, it seems to me it's the same thing - but it
is only 6:15 in the morning and I've only had one cup of coffee. :-)

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


"Martin Stabrey" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Kathleen
>
> Gee, you've certainly been a wealth of information! Thanks again for all
> your help.
>
> Unfortuantely, the "All Values" wildcard does exactly opposite of what I
> want ie. I am needing to exclude a field from a query if no selection is
> made.
>
> I suppose what I need is a sort of "No Values" wildcard :-)
>
> Thanks again.
>
> Martin
>
> "Kathleen Anderson" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Hi Martin:
>> This article How to add an All Values item to a database query by using
>> the FrontPage 2003 Database Results Wizard
>> http://support.microsoft.com:80/kb/825453 might help. If the user doesn't
>> make a selection, it should use the All Values as the default.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
>> FrontPage Resources: http://www.spiderwebwoman.com/resources/
>> Please reply to the newsgroup for the benefit of others
>>
>>
>> "Martin Stabrey" <(E-Mail Removed)> wrote in message
>> news:2228AE82-93F8-4E15-98DC-(E-Mail Removed)...
>>> My search form has 5 fields (all drop-down lists) that are all
>>> empty/blank to start with ie. the first option of each list is
>>> <option></option> in the HTML. The user can select data from any of the
>>> 5
>>> fields. Some fields may be left unfilled when the form is submitted to
>>> the
>>> DBRW.
>>> I am using the And comparison for each field - so, as an example, if the
>>> user chooses an option from list 1 and an option from list 4, I would
>>> like
>>> only the records that match and are common to both lists returned for
>>> viewing.
>>>
>>> My problem is that the fields that are left untouched by the user are
>>> being
>>> queried along with the filled fields (which is the way it should work
>>> :-) )
>>> I would like them to be ignored. Empty fields should not influence the
>>> query
>>> at all.
>>>
>>> How can I achieve this? Apologies for the nonDB speak. Quite raw at all
>>> of
>>> this, but learning alot!
>>>
>>> Mart
>>>
>>>
>>
>>
>
>

I could certainly give that a go and see what happens.
As a matter of interest, do you know how this "All Values" is used in a text
field, as opposed to a drop down list?
I'm almost having my first glass of wine, being on the other end of the
world :-)

Mart
"Kathleen Anderson" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Martin:
> I think if you think about, it would accomplish the same thing. Looking
> for "All Values" of a field would give you the same results as not using
> the field in your query. At least, it seems to me it's the same thing -
> but it is only 6:15 in the morning and I've only had one cup of coffee.
> :-)
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> FrontPage Resources: http://www.spiderwebwoman.com/resources/
> Please reply to the newsgroup for the benefit of others
>
>
> "Martin Stabrey" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi Kathleen
>>
>> Gee, you've certainly been a wealth of information! Thanks again for all
>> your help.
>>
>> Unfortuantely, the "All Values" wildcard does exactly opposite of what I
>> want ie. I am needing to exclude a field from a query if no selection is
>> made.
>>
>> I suppose what I need is a sort of "No Values" wildcard :-)
>>
>> Thanks again.
>>
>> Martin
>>
>> "Kathleen Anderson" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Hi Martin:
>>> This article How to add an All Values item to a database query by using
>>> the FrontPage 2003 Database Results Wizard
>>> http://support.microsoft.com:80/kb/825453 might help. If the user
>>> doesn't make a selection, it should use the All Values as the default.
>>>
>>> --
>>>
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
>>> FrontPage Resources: http://www.spiderwebwoman.com/resources/
>>> Please reply to the newsgroup for the benefit of others
>>>
>>>
>>> "Martin Stabrey" <(E-Mail Removed)> wrote in message
>>> news:2228AE82-93F8-4E15-98DC-(E-Mail Removed)...
>>>> My search form has 5 fields (all drop-down lists) that are all
>>>> empty/blank to start with ie. the first option of each list is
>>>> <option></option> in the HTML. The user can select data from any of the
>>>> 5
>>>> fields. Some fields may be left unfilled when the form is submitted to
>>>> the
>>>> DBRW.
>>>> I am using the And comparison for each field - so, as an example, if
>>>> the
>>>> user chooses an option from list 1 and an option from list 4, I would
>>>> like
>>>> only the records that match and are common to both lists returned for
>>>> viewing.
>>>>
>>>> My problem is that the fields that are left untouched by the user are
>>>> being
>>>> queried along with the filled fields (which is the way it should work
>>>> :-) )
>>>> I would like them to be ignored. Empty fields should not influence the
>>>> query
>>>> at all.
>>>>
>>>> How can I achieve this? Apologies for the nonDB speak. Quite raw at all
>>>> of
>>>> this, but learning alot!
>>>>
>>>> Mart
>>>>
>>>>
>>>
>>>
>>
>>
>
>