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

Table rounds all numbers to whole integers

P: n/a
I cannot figure out how to have a field in a simple table retain decimal
parts of a whole number (integer). These values are immediately rounded up
or down to the nearest integer. Any help is appreciated.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
News wrote:
I cannot figure out how to have a field in a simple table retain
decimal parts of a whole number (integer). These values are
immediately rounded up or down to the nearest integer. Any help is
appreciated.


If you remember your basic math classes integers are numbers without a
fractional component so that is why decimals are truncated. If you want
fractional values you need to use Single, Double, Currency, or the newer
Decimal type (although there are pretty big bugs associated with the last).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.