Parameter Query Options

[=?Utf-8?B?VG9ueSBBLg==?=]

L've created a parameter query where the options are True, False and All.
Using a combo box the user can select on of these options. Getting True or
False to work is easy. Howe do I select both options when All is selected?
--
Tony

[zacks]

On Feb 2, 2:53 pm, Tony A. <[e-mail]:

L've created a parameter query where the options are True, False and All.
Using a combo box the user can select on of these options. Getting True or
False to work is easy. Howe do I select both options when All is selected?

Post the SQL code. What is the datatype of the parameter?

[Cor Ligthert [MVP]]

Tony

You mean you have an SQL clause as

Select * from TabelX where y = @y

And you will now dynamicly remove that where. I thought that typical from
SQL procedure is that you cannot remove that where.

All true and false does of course not exist, if it is both, than it means
there is no criteria.

Cor

"Tony A." <To***@discussions.microsoft.comschreef in bericht
news:DC**********************************@microsof t.com...

L've created a parameter query where the options are True, False and All.
Using a combo box the user can select on of these options. Getting True
or
False to work is easy. Howe do I select both options when All is
selected?
--
Tony

[RobinS]

Cor, in that case, I'd use two different sp's, one with the boolean, and
one without.

Robin S.
-------------------------------------
"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:u4**************@TK2MSFTNGP03.phx.gbl...

Tony

You mean you have an SQL clause as

Select * from TabelX where y = @y

And you will now dynamicly remove that where. I thought that typical from
SQL procedure is that you cannot remove that where.

All true and false does of course not exist, if it is both, than it means
there is no criteria.

Cor

"Tony A." <To***@discussions.microsoft.comschreef in bericht
news:DC**********************************@microsof t.com...

>L've created a parameter query where the options are True, False and
All.
Using a combo box the user can select on of these options. Getting True
or
False to work is easy. Howe do I select both options when All is
selected?
--
Tony