Use of percentage

[MisterMan]

Hi all,

Ran into an odd problem today. I have a field in one of my tables that is updated when a macro is run. When the macro is run, it takes the values from two other fields and does a calculation (Well, the macro does, but anyway) in theory this then displays the result of this calculation within the field itself (called Increase).
Now, for some reason? This field will _NOT_ allow for their to be decimal places, everything rounds up.
I have tried to figure out why it is doing this, but I cannot for the life of me find one reason why it should be.
Any help would be appriciated!
J

 

[adrikev]

Check the Field Size Property fo the Data Type for that field. Single and Double are the only properties that support decimal points. Depending on the decimal precision you want choose one of those.

Single - 7 decimal places - 4 bytes
Double - 15 decimal places - 8 bytes --------------------------------
Fortius, Citius, nullis secundus
Strength, Speed, second to none