numbers rounding up in table

[Michael C via AccessMonster.com]

I have several tables that have numbers displaying 2 digits to the right of
the decimal. However, when I append these into a common table, all numbers
are suddenly rounded up to the nearest whole number. I tried to set at a
Fixed format , with the Decimal setting on both Auto and 2. It still rounds
up. Any ideas why?

Thanks,

Perry

--
Message posted via http://www.accessmonster.com

[RoyVidar]

Michael C via AccessMonster.com wrote in message <5a2b5211322dc@uwe> :

I have several tables that have numbers displaying 2 digits to the right of
the decimal. However, when I append these into a common table, all numbers
are suddenly rounded up to the nearest whole number. I tried to set at a
Fixed format , with the Decimal setting on both Auto and 2. It still rounds
up. Any ideas why?

Thanks,

Perry

Perhaps the field size property - I'm guessing you have Integer, while
you would need Single, Double or the datatype Currency.

--
Roy-Vidar

[Michael C via AccessMonster.com]

Thanks, that worked. Changed it to double and it works now.

RoyVidar wrote:

Michael C via AccessMonster.com wrote in message <5a2b5211322dc@uwe> :

I have several tables that have numbers displaying 2 digits to the right of
the decimal. However, when I append these into a common table, all numbers

[quoted text clipped - 5 lines]

Perry

Perhaps the field size property - I'm guessing you have Integer, while
you would need Single, Double or the datatype Currency.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200601/1