|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
03-23-2003, 08:14 PM
|
#1 |
|
Member (6 bit)
Join Date: Jan 2003
Location: Buffalo, NY
Posts: 63
 |
access numbers do not stay as entered
I have a simple Access 2000 database. With an autonumber field, last name, first name, date, file #, and hours fields. I am trying to track # of vacation hours taken. I have the vac hours field formated as a long integer with a standard number form. But when I go to enter in 36.5 it automatically changes it to 36.00. What the heck? Can someone please help.
|
|
|
|
03-23-2003, 10:19 PM
|
#2 |
|
Barefoot on the Moon!
Staff
Premium Member
Join Date: Aug 2002
Location: Northeastern USA
Posts: 13,385
|
My guess is that it is rounding. Unfortunately, I don't know access well enought to tell you where to change it. Try looking in Tools > Options > "Tables/Quiries" tab. What does the field size for intergers say?
__________________
There are two secrets to staying young, being happy, and achieving success. You have to laugh and find humor every day, and you have to have a dream.
|
|
|
|
|
03-24-2003, 12:26 PM
|
#3 |
|
Member (6 bit)
Join Date: Jan 2003
Location: Buffalo, NY
Posts: 63
|
I figured it out. I was using a long integer format. which I guess doesn't use decimals. I changed it to double and now it seems to work. Thanks anyway all.
|
|
|
|
|
03-24-2003, 12:38 PM
|
#4 |
|
Member (11 bit)
Join Date: Dec 2001
Location: Shakopee MN
Posts: 1,293
|
correct,
byte, integer, long integer have NO decimal places decimal has 28 decimal places single has 7 double has 15 to check out the details, go into the table in design view and place the cursor in the 'field size' text box and press F1 |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
