I am trying to create a retrieve spec on a boolean check box with no success.

I only want the spec to retrieve those records where the condition is 0, NO, False, etc.  The field is set to Yes/No.

I tried the program editor on the field but to no avail.

Any thoughts ?

Thanks,

Louis

Hello Louis,

If it is a boolean check box then all need to do is click the check box until it is at the 'No' setting and hit F10 to retreive the records. A check box has three different settings, they are Yes, No and N/A.

Yes has a Check mark in it
No is a down box with your background color of the check box showing
N/A is an up box with the background color of your Form.

If you are unsure of what value your check box is set to then just hit F6 to bring up the field editor when the check box has focus. The field editor will display one of three things. If it has a 1 then it is Yes,  if it has a 0 then it is No, if it is blank then it is N/A. You can also enter a 0 into the field editor and hit F6 an that will set the check box to the 'No' state.

If you have any questions let me know,
-Ray

Hello Louis,

If you select No, Hit F10 and a message appears in the lower left hand corner saying "No records returned by query" then there are no records that have a value of 0 in the check box, but they could have a blank.

Try this instead:
On your retrieve spec change your check box to be checked.
On the menu tree choose "Inverted Search"

This will get you all the records that do not have a 1 in the checkbox, which includes both the '0' records and the blank records.


Erika said that Radio and Check buttons only allow you to choose one option at a time not that they only offer one choice.

-Ray