Setting the level of precision

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me how to se the level of precision when defining criteria
for a field. For example: I am trying to limit my result set to anything >
0 but I have noticed that when I use only >0 it will some times drop off
smaller numbers like .02. Any help would be appreciated.

Thanks,
Anthony
 
Access does not allow you to specify precision separately to the data type.
The following shows the built in precision levels.

Itsounds like your problem is more to do with display and rounding?


Setting Description Decimal precision Storage size
Byte Stores numbers from 0 to 255 (no fractions). None 1 byte
Decimal Stores numbers from -10^38-1 through 10^38-1 (.adp)
Stores numbers from -10^28-1 through 10^28-1 (.mdb) 28 12bytes
Integer Stores numbers from -32,768 to 32,767 (no fractions). None 2
bytes
Long Integer (Default) Stores numbers from -2,147,483,648 to
2,147,483,647 (no fractions). None 4 bytes
Single Stores numbers from
-3.402823E38 to -1.401298E-45
for negative values and from
1.401298E-45 to 3.402823E38 for positive values. 7 4 bytes
Double Stores numbers from
-1.79769313486231E308 to
-4.94065645841247E-324
for negative values and from
4.94065645841247E-324 to
1.79769313486231E308 for positive values. 15 8 bytes
Replication ID Globally unique identifier (GUID) N/A 16 bytes
 
Back
Top