Option group in report...

[Pangloss14]

Hi,

I have a report with an option group that links to a field with values between -2 and 2. Is there any way to make an option group with only two choices, one choice is if the value is 0, and the other choice if it's any other value. It seems like it should be simple enough but I've been puzzling over this for a bit.

Thanks

 

[Pat Hartman]

You will need to "summarize" the data in a query so that you have only the two values.

Select ...., IIf(YourField = 0, 1, 2) As CmbValue
From YourTable;