Access data type problem

Results 1 to 2 of 2

Thread: Access data type problem

  1. #1
    Join Date
    Dec 1969

    Default Access data type problem

    Hi,<BR><BR>I&#039;m using access 97. I have a numeric field in which I want to insert a number which has 3 numbers after the decimal. I don&#039;t know how access does this. In the properties of the numeric field I have:<BR><BR>Field size : long integer<BR>Decimals : 3 <BR><BR>The thing is when I insert a number such as 0.125, it just reverts it to 0.000. How do I stop it from doing this.<BR><BR>thanks for your help

  2. #2
    Join Date
    Dec 1969

    Default Make it a Double (Not a Long Integer) <eop�


Posting Permissions

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