By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,316 Members | 2,132 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,316 IT Pros & Developers. It's quick & easy.

numbers rounding up in table

P: n/a
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
Jan 10 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jan 10 '06 #2

P: n/a
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
Jan 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.