G
Guest
I have several percentage fields that are causing endless problems. I
originally had them as numbers and divided by 100 for my calculations but the
user insisted on % signs on the forms so I changed them all to percent
fields. Now my problems have begun! I have 2 problems:
(1) Some of the fields when I click in the control on the form I see the
decimal value e.g. if I click on 17.50%, then it changes to .175 This only
happens in some controls even though they are all defined EXACTLY the same
way.
(2) I have to check that several of the fields on a form add up to 100%,
since they are percent fields they should actually add up to 1. The weirdest
thing is happening, they do add up to 1 (I displayed the individual values)
and I confirmed with a message box for the total but my IF test for <>1
SUCCEEDS!!!! I am using a SINGLE field to do the additions, is this the
problem. I tried using a DOUBLE field and that added up to something like
1.00000253 why I have not a clue. This only happens with one set of values
even though with another identical set of values the <>1 test FAILS.
Can anyone throw some light on all this???
originally had them as numbers and divided by 100 for my calculations but the
user insisted on % signs on the forms so I changed them all to percent
fields. Now my problems have begun! I have 2 problems:
(1) Some of the fields when I click in the control on the form I see the
decimal value e.g. if I click on 17.50%, then it changes to .175 This only
happens in some controls even though they are all defined EXACTLY the same
way.
(2) I have to check that several of the fields on a form add up to 100%,
since they are percent fields they should actually add up to 1. The weirdest
thing is happening, they do add up to 1 (I displayed the individual values)
and I confirmed with a message box for the total but my IF test for <>1
SUCCEEDS!!!! I am using a SINGLE field to do the additions, is this the
problem. I tried using a DOUBLE field and that added up to something like
1.00000253 why I have not a clue. This only happens with one set of values
even though with another identical set of values the <>1 test FAILS.
Can anyone throw some light on all this???