How do I declare a boolean querydef parameter?

  • Thread starter Thread starter Stan
  • Start date Start date
S

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.
 
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
 
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
 
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
 
Back
Top