Access 2000 Inventory template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
kmhanson said:
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.
Click to expand...

Usually means that you have set the field length to Integer or LongInteger
neither of which support fractional values.
 
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.
 
Back
Top