How to revalue an option buttons

[Jon]

Hi,
I have option group in from to add values in table. These options use to add
a percentage to the table. The first one has 50% labels; the second one has
55% and so on to 100%. The problem is when I retype the value of each option
from 1 to 0.50 the value returns to 0. Can any body help me revaluing the
value of each option?
Thanks!!

 

[Ofer Cohen]

Check the field type, if its Long or Integer it will round the number and 0.5
will turn into 0.
Change the field type to Double or Single

 

[Jon]

hi,
which field you meant please?

Check the field type, if its Long or Integer it will round the number and 0.5
will turn into 0.
Change the field type to Double or Single

 

[Ofer Cohen]

The field in the table,
I assumed from your post that when you are trying to store 0.5 it will round
to 0

 

[Jon]

hi,
I did that but the problem still
thanks!!

The field in the table,
I assumed from your post that when you are trying to store 0.5 it will round
to 0

 

[Jon]

By the way, the major reason of making the value to be 0.50 to be store as %,
the format of the filed is percent

 

[fredg]

Hi,
I have option group in from to add values in table. These options use to add
a percentage to the table. The first one has 50% labels; the second one has
55% and so on to 100%. The problem is when I retype the value of each option
from 1 to 0.50 the value returns to 0. Can any body help me revaluing the
value of each option?
Thanks!!

The value of an option group cannot be a decimal value.
The value of the group is determined by the value of each button
within the group. That value is an Integer value, i.e. 1, 2, 3, etc.

That integer value is what is stored in your table when an option
value is selected.

To work with the selected value, you would use an expression in a
query (or directly on a form or report) and convert the Integer value
to whatever other value you wish.
For example, to display in a query an increase in FieldA of .25, .50,
or .75 or no increase if option 1, 2, 3 or no option is selected ...
ChangeValue:IIf([OptionGroup] = 1, [FieldA]*1.25,IIf([OptionGroup] =
2, [FieldA] * 1.5,IIf([OptionGroup] = 3,[FieldeA]*1.75,[FieldA])))

I hope this helps you understand Option Groups.