Reports from tick boxes

[tiruchi]

Hello,

If I have several tick boxes and want the user to tick only one of
them, how is it possible to generate the result into a report.
Basically I want to be able to convert the tick box to text. This is so
that grouping within the reports is easier.
(e,g. if there are tick boxes for enquiries 'via email', 'phone', 'fax'
etc.. and if only one of them needs to be ticked, so that the report
will generate enquiries sorted and based on mode of receipt). Hope I
have been clear.

thanks in advance for all your support.

 

[Al Camp]

Tiruchi,
For several check boxes, with only one allowed at a time, use an
OptionGroup instead of individual checkboxes.
But, since the output of an option group is a numeric value, before the
report query can operate on your criteria, you'll have to convert the
numeric result of the OptionGroup to a corresponding Textual criteria.
IIF... 1 = "E Mail" 2 = Fax 3 = Phone etc...
As you can see, that could get pretty clumsy...

I would suggest a combo box that lists the same values as in the table
you are querying for your report. Then your report query criteria can
directly address the value on your open criteria form. (use your own names)
= Forms!frmYourFormName!cboContactedVia
Use the same data table as the report uses to "feed" the combo the values
it needs to make a legitimate selection.

 

[tiruchi]

Thanks very much Al. Managed the option group ok. With a bit of playing
around think have managed the second part of your suggested method.