Field Formatted % Inputs -> 0.00%

T

TKS_Mark

I have fields in a table with datatype = number, field size = long integer,
format = percent, and decimal places = auto. When I try to enter numbers
into these fields w/ this format, they return to 0.00% as soon as I hit
return. Why won't my numbers update?

Thanks!
 
B

Beetle

You need to use a floating point data type, either single or double. Which
one depends on how long your numbers are, what level of accuracy you need
etc.
 
T

TKS_Mark

Excellent!

Beetle said:
You need to use a floating point data type, either single or double. Which
one depends on how long your numbers are, what level of accuracy you need
etc.
 

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

Top