Access is rounding off numbers and I don't wan

Results 1 to 2 of 2

Thread: Access is rounding off numbers and I don't wan

  1. #1
    Join Date
    Dec 1969
    Posts
    730

    Default Access is rounding off numbers and I don't wan

    Hi, I&#039m trying to store the number<BR><BR>0.008991 in a database but Access seems to think it&#039s acceptable to round it off to 0.009000. How can I prevent it doing this. Basically, I wan&#039t absolutely no rounding.<BR><BR>Cheers<BR>Tom

  2. #2
    ozKen Guest

    Default RE: Access is rounding off numbers and I don't

    I had a problem with Access rounding to integers. I changed the format Access accepted from Long Integer (or whatever was the default) to Single. I think that fixed my problem, so you may want to experiment with the fields and their format and see what you come up with.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •