If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
decimal place
I am creating a table, under a field type I chosed mumber, and under that I
chosed standard and under decimal place I chosed 2. And I have saved the changes. The problem is I always get a number with no decimal place. Why, and how can a get 2 decimal place for that number? |
#2
|
|||
|
|||
Try choose a number type like Double or Single rather than Long Integer or
Integer. -- Duane Hookom MS Access MVP -- "Wtao" wrote in message ... I am creating a table, under a field type I chosed mumber, and under that I chosed standard and under decimal place I chosed 2. And I have saved the changes. The problem is I always get a number with no decimal place. Why, and how can a get 2 decimal place for that number? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Does field have to be decimal to store decimal places | HB | General Discussion | 4 | February 15th, 2005 02:33 AM |
Decimal Place problem | Niall | Running & Setting Up Queries | 2 | January 21st, 2005 01:30 PM |
date calculation and decimal places | Mary | Running & Setting Up Queries | 2 | December 7th, 2004 07:17 PM |
Decimal points on an excel mail merge | Wishart1 | Mailmerge | 1 | November 12th, 2004 12:05 AM |
Limit text length to the 4th decimal place | roxyr | Worksheet Functions | 3 | June 23rd, 2004 01:14 AM |