Check Boxes, Values of, reports using.

[Arcanoi]

I am currently trying to make a report that looks to see if a checkbox is checked or not, but am having trouble everywhere I turn, including even making the checkbox value, I understand how to do it logistically, just not in practice... if anyone could help me and wishes to try and discuss the details over email please email me at [email protected] if you would rather type the reply here that is fine as well. Thank you in advance

[-Queue-]

If a box is checked, then its value equals the selected option or one of the options selected. For example, a checkbox with values A, B, and C selected would equal A

[Arcanoi]

Okay got that part but how do I make a check box with only one selectable option?

[-Queue-]

Format it to use a value list that contains only one value.

[Arcanoi]

I understand the usage of value lists but if it's only a value list how do I do a query on it since a query can only be pulled on a field?

[-Queue-]

The field is formatted as a value list for selection purposes only; it is still just a field. To find records that have it selected, enter find mode, check the box, and press Enter.

[Arcanoi]

To make a report using only the ones that have it unchecked I would do a find not equal to value of the box?

[-Queue-]

You would check the box in find mode and then click the Omit box in the Status Area.

[Arcanoi]

I am trying to use a script to generate a report in a list format, showing only those records that are not checked, is there a easy way to do this?

BTW thanks for the help Queue.

[-Queue-]

Sure.

Set Error Capture [On]

Enter Find Mode [ ]

Set Field [text; "value"]

Omit Record

Perform Find [ ]

If [not Get ( FoundCount ) ]

Show Custom Dialog ["There are no records not checked."]

Halt Script

End If

{remainder of reporting steps}

Alternately, you can Set field [text, "="]

Perform Find [ ]

instead of the Set Field and Omit steps, since = will find records with 'text' field empty.

[Arcanoi]

an alternate is perform find [options] is it not? I mean I don't need to set the field if I have it.

[-Queue-]

Yes, just make the criteria =. I rarely use Perform Find [restore], since the criteria must be hard-coded. In this situation it should work though.