Access rounding numbers!

Results 1 to 2 of 2

Thread: Access rounding numbers!

  1. #1
    Join Date
    Dec 1969

    Default Access rounding numbers!

    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
    Join Date
    Dec 1969

    Default RE: Access rounding numbers!

    Try changing your datatype to a Double instead of a long integer... try also specifying the decimal places

Posting Permissions

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