typing in the decimal character 1

[sblanche]

In my table, I have a field with the data type of "number" and the "decimal places" set to "auto". When I type in .20 or anything with the "." it changes the entry to 0. I have tried changing the "decimal places" to 2 but it still does not recognize the ".". I can type in numbers without the . and the numbers stay ok. If I set the field type to "text" I have problems with calculations.

Any help will be greatly appreciated.

SLB

 

[PHV]

You have to use Single, Double, Currency or Decimal field size instead of Integer or Long.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LittleSmudge]

Data type set to Number - Yes,

BUT what type of number ?

If it is Integer, Byte, Long Integer etc then it will only hold whole numbers

to take fractions you need Single or Double ( or Currency )

Look at the block at the bottom of the screen when the row with this field is selected at the top and you'll see the options you have.


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[sblanche]

Thanks--Changing to Single Worked--