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
|
|||
|
|||
Number formats
I am building a database that has a contracts table, which
contains various information about our different contracts. I have pay methods fields and description fields, ex. paymethod1, description1, paymethod2, description2. I need the paymethod fields to be formatted in such a way that I can enter numbers such as 1500.00 or .12, because the pay method can be different for each contract some are a percent of something and some are flat fees. I have been trying different number formats and custom number formats, but every time I enter a number beginning with a decimal point and tab to the next field it changes the value to zero. Any tips on how to solve this problem? |
#2
|
|||
|
|||
Number formats
Andrea,
In addition to what Tim said about normalizing your data, you should check the Field Length of the number fields. If they are set to Long Integer, then you should change them to Double. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Andrea" wrote in message ... I am building a database that has a contracts table, which contains various information about our different contracts. I have pay methods fields and description fields, ex. paymethod1, description1, paymethod2, description2. I need the paymethod fields to be formatted in such a way that I can enter numbers such as 1500.00 or .12, because the pay method can be different for each contract some are a percent of something and some are flat fees. I have been trying different number formats and custom number formats, but every time I enter a number beginning with a decimal point and tab to the next field it changes the value to zero. Any tips on how to solve this problem? |
#3
|
|||
|
|||
Number formats
I am not sure if this makes any difference but the numbers
in the paymethod feilds will be strictly for informational purposes no calculations will be done with them. All I need is for the numbers to show. -----Original Message----- Andrea, In addition to what Tim said about normalizing your data, you should check the Field Length of the number fields. If they are set to Long Integer, then you should change them to Double. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Andrea" wrote in message ... I am building a database that has a contracts table, which contains various information about our different contracts. I have pay methods fields and description fields, ex. paymethod1, description1, paymethod2, description2. I need the paymethod fields to be formatted in such a way that I can enter numbers such as 1500.00 or .12, because the pay method can be different for each contract some are a percent of something and some are flat fees. I have been trying different number formats and custom number formats, but every time I enter a number beginning with a decimal point and tab to the next field it changes the value to zero. Any tips on how to solve this problem? . |
#4
|
|||
|
|||
Number formats
No, that won't make a difference. If the number fields are INTEGER, then
they cannot have decimals. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Andrea" wrote in message ... I am not sure if this makes any difference but the numbers in the paymethod feilds will be strictly for informational purposes no calculations will be done with them. All I need is for the numbers to show. -----Original Message----- Andrea, In addition to what Tim said about normalizing your data, you should check the Field Length of the number fields. If they are set to Long Integer, then you should change them to Double. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Andrea" wrote in message ... I am building a database that has a contracts table, which contains various information about our different contracts. I have pay methods fields and description fields, ex. paymethod1, description1, paymethod2, description2. I need the paymethod fields to be formatted in such a way that I can enter numbers such as 1500.00 or .12, because the pay method can be different for each contract some are a percent of something and some are flat fees. I have been trying different number formats and custom number formats, but every time I enter a number beginning with a decimal point and tab to the next field it changes the value to zero. Any tips on how to solve this problem? . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Input a user version number via hyperlink/ASK/input box | Michael | Page Layout | 1 | May 28th, 2004 07:42 PM |
make a function that add number 1 in another number | Manos | Worksheet Functions | 3 | February 3rd, 2004 01:37 PM |
Need a formula to count the number of digits in a number. | Biff | Worksheet Functions | 1 | January 24th, 2004 06:01 AM |
Number format problem in CSV files | Mervyn Thomas | Worksheet Functions | 3 | January 14th, 2004 05:31 PM |
Is there a formula to tell me if one number is a multiple of another number? | Marvin Hlavac | Worksheet Functions | 4 | November 28th, 2003 02:33 AM |