Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The format for a field in a table has nothing to do with how it is stored. You must have the correct Field Type, Length, and Decimal places defined and the saved amount will be correct:

image description

If you have an incorrect field type (such as Integer) or the number of decimals in Field Properties is not set correctly, no matter what format you use it will not work.