Double field size in MS Access

Asked By sarmadmunir 30 points N/A Posted on - 04/01/2012

In MS Access, what is the "Double" field size, and how does it differ from "Long Integer"?

• Status: Open
• Question Views: 2074
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Chung Opi 5 points N/A #155102

Double field size in MS Access

In MS Access both double and long integer are number types and they both differ from each other. Double can hold values of floating point number to decimal precision of 15 and it has the storage capacity of about 8 bytes.

Whereas long integer hold only integer and also holds floating point number by converting them automatically to integer. The memory of integer is less than double that is 4 bytes.

For example if you store this number 12345.123 in double it will store it as it is, but in long integer it will restore it as 12345 and leave the floating point number.

About Chung Opi

Questions
2

Answers
50

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 04/02/2012
• Question Category: MS Access