Parameter Query Options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

Post the SQL code. What is the datatype of the parameter?
 
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
 
Cor, in that case, I'd use two different sp's, one with the boolean, and
one without.

Robin S.
 
Back
Top