field format in table design rounding the input

[dfeigen115]

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

 

[Jeff Boyce]

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

 

[dfeigen115]

Jeff,
That was it. I switched the type oo currency and the data imported
correctly, Thanks agin,
Dan