Does field have to be decimal to store decimal places

[Guest]

I have a field, Hours Worked defined on the table as an integer with 2
decimal places. On the form, it will not accept decimal places. Does it have
to be defined as a decimal to accept it on the form?

 

[Rick Brandt]

I have a field, Hours Worked defined on the table as an integer with 2
decimal places. On the form, it will not accept decimal places. Does it have
to be defined as a decimal to accept it on the form?

Look up the definition of an integer and you have your answer (hint: no
fractional values).

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

 

[M Davidson]

Integers don't have a decimal value. They round to a whole number.
In the table choose "number"

In the field's Property sheet>General>Field size Choose either single or
double

I'm a newbie but I think that's right

 

[M.L. Sco Scofield]

Sorry HB. You need to get out your algebra book.

The definition of an integer is a whole number. No fractions.

If you want decimal places, you need to use a single or double precision
number type. Just be sure to watch out for rounding issues. Another option
would to be to use the decimal number type.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Joseph Meehan]

I have a field, Hours Worked defined on the table as an integer with 2
decimal places. On the form, it will not accept decimal places. Does
it have to be defined as a decimal to accept it on the form?

in·te·ger (¹n"t¹-j.r) n. Mathematics. 1. A member of the set of positive
whole numbers (1, 2, 3, . . . ), negative whole numbers (-1, -2, -3, . .
.. ), and zero