Access Clobberring Data: Losing Digits

Factual Questions
1

Okay.
I have a Access MDB file I use to manage my business inventory. There is only one table that matters.

I am trying to bring in data from another app by saving the data to a tab-delimited file and then importing into Access.

The data comes in nicely from the other file into a table in Access.
When I’m copying the data into the main table in my MDB… the data turns into just integers. No post-decimal information is displayed.

The field in the MDB file that is giving me fits is named ‘manp3’.
I’m looking at it right now in Access.
Data type is Number.
Field Size is Integer.
Required is No.
Indexed is No.
Text Align is General.

Any clues?

2

Change the field size to ‘Double’. You have it set up to show only integers right now.

3

That fixed it.
Thanks!

4

If you’re going to be using these numbers for multiplication or division, I’d suggest you store them as Currency or Decimal rather than Double; those are exact data types that don’t cause rounding errors. With Double, there are usually rounding errors that get quite annoying after a bit when your output is 4.99999987 rather than 5.0.