problem with numbers

E

Evil One

Field data type is Number. When I put numbers like 1, 2, 3, 4 (they
represeting number of hours) everything is OK, but when I put half hour
(like 0,30, 1,5 or something) Access change that (0,30 in 0; 1,5 in 2). What
is wrong? How to put half of hour in filed?

Thanx!
 
W

Wayne Morgan

Open the table in design mode. Click on the field. Look near the bottom. The
default Number type is Long Integer. Change to Single or Double to allow
decimal numbers.
 
Z

Zlo Koje Surfa

Thanx. Working!

Wayne Morgan said:
Open the table in design mode. Click on the field. Look near the bottom. The
default Number type is Long Integer. Change to Single or Double to allow
decimal numbers.
Click to expand...
 
Top