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.
 

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