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.
 

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
Percentage code 2
Field Formatted % Inputs -> 0.00% 2
How do i assign a calculated value to a table in access 5

Back
Top