displaying percents in tables Access 2000

D

Dave B

Hi,

I am trying enter 8.00% into a field within a table, and i keep getting
800.00% how do i go about rounding it down so it is retains that orginal
figure of 8%.

The Datatype is set to number and the format is set to percent with 2
decimal places.

Many Thanks

Dave
 
R

Rolls

Enter 0.08 or create a function to divide 8 by 100 and store the result into
your table.
 

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

Percent help 3
% and numbers 2
Format a Percent 4
Percent value rounds up in Access 1
How do I input number in Access data type=number; format=percent 5
Format a percent 7
Formatting a percent field 1
Format a percent field 1

Top