field format in table design rounding the input

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

Guest

I have a field in a table that will contain values from 0.000 to 1.000 and
will ulitmately be used in a calculation. The source values are being
imported from an excel spreadsheet. I've tried a variety of formats in the
table design, but the values consistently end up as 1.

recommendations?
Thanks,
Dan
 
Dan

Re-check the field's definition. It sounds like the data type is Integer,
which can only hold whole numbers.

If you don't need more than four decimal places, take a look at the Currency
data type.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,
That was it. I switched the type oo currency and the data imported
correctly, Thanks agin,
Dan
 
Back
Top