Percentage format

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?
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add and show vat to an exisiting amount and show total 16
Decimal places in a temporary table 3
Fuel VAT Calculations 5
Percentage in a form field used for formula calculation 2
Adding Caluclated Field to table 3
Field Formatted % Inputs -> 0.00% 2
Percentage code 2
Access database sum calculation error 0

Top