How do I declare a boolean querydef parameter?

[Stan]

The table field that I'm referencing with my parameter is
a boolean (yes/no) field. I need to know how to declare
the parameter in the querydef.

 

[Immanuel Sibero]

Hi

Right click on the upper part of query design screen (where table
relationships are graphically shown). Choose Parameters. You can then define
parameters with their types.

HTH
Immanuel Sibero

 

[Guest]

Thanks! Now, when I want to set the value of the
parameter to true or false, do I prompt the user to enter
yes/no or true/false or maybe -1 or 0?

Stan

 

[Immanuel Sibero]

Hi

Any one you mention will work.

You may check me on this but I think this is right:

Yes, True, Non-zero will evaluate to -1 (i.e. True)
No, False, 0 will evaluate to 0 (i.e. False)


HTH
Immanuel Sibero