Numbers and Decimals

[Dan]

I have a table with a field hours type is numeric and the
format I have changed from general to fixed to standard
with the results being the same. if I enter 2.34 it
returns 2 if I enter 2.67 I get 3 the only way I found to
get 2.34 or 2.67 or whatever is to make it a text. How can
I do this and leave it a number?

 

[Gerald Stanley]

Put the table into Design View, set the column's DataType
to Numeric and set its FieldSize to Double.

Hope This Helps
Gerald Stanley MCSD

 

[Rick Brandt]

I have a table with a field hours type is numeric and the
format I have changed from general to fixed to standard
with the results being the same. if I enter 2.34 it
returns 2 if I enter 2.67 I get 3 the only way I found to
get 2.34 or 2.67 or whatever is to make it a text. How can
I do this and leave it a number?

What *kind* of number? Integer and Long Integer don't support decimals
(they're integers after all).

If you want fractional values you need to use Single, Double, or Currency.