Percentage format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help?
I can't get the data table to read the correct format for percentages.
Attempt to pre-load tax of 17.5% into a field in a table.
Field name - VAT
Data Type - Number
Format - Percent
Decimal places - 2
Default value - tried 17.5 (gives table value of 1800%) or .175 (gives table
value of 0.00%)
I can't get the table to read 17.5% in any way.
What am I doing wrong?
 
The default Field Size for the Number Data Type is Long Integer. Integers
can't store any decimal places. Make sure you've changed it to Single or
Double.
 
Back
Top