|
| 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
March 31st, 2007, 04:04 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Access 2000 Inventory template
I am trying to enter decimal numbers in the Purchase Orders subform and it is
rounding the numbers. I have opened the Inventory Transaction table in design view and fiddled with a few of the setting to see if it was because of how the numbers were entered, but it didn't seem to change anything. Any suggestions? I need to keep track of items that are not purchased in whole number increments. 
|
|
#2
March 31st, 2007, 01:47 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Access 2000 Inventory template
kmhanson wrote:
I am trying to enter decimal numbers in the Purchase Orders subform and it is rounding the numbers. I have opened the Inventory Transaction table in design view and fiddled with a few of the setting to see if it was because of how the numbers were entered, but it didn't seem to change anything. Any suggestions? I need to keep track of items that are not purchased in whole number increments. Usually means that you have set the field length to Integer or LongInteger neither of which support fractional values. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#3
March 31st, 2007, 02:02 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Access 2000 Inventory template
Originally it was set to Long Integer. I changed it to Decimal, changed the
Format to Fixed and set the number of places to 3. It is still rounding. I tried looking in the subform to see if there was something there to force the field to round, but I am not entirely sure what to look for. "Rick Brandt" wrote: kmhanson wrote: I am trying to enter decimal numbers in the Purchase Orders subform and it is rounding the numbers. I have opened the Inventory Transaction table in design view and fiddled with a few of the setting to see if it was because of how the numbers were entered, but it didn't seem to change anything. Any suggestions? I need to keep track of items that are not purchased in whole number increments. Usually means that you have set the field length to Integer or LongInteger neither of which support fractional values. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
