Roz has attended:
Access Intermediate course
Access Introduction course
Microsoft Access Foundation
What does 'Double' mean in the Field Size in design view?
RE: Microsoft Access Foundation
Hi Roz
When you design a field you need to specify how much memory will be set aside for the data. When dealing with numbers you need to tell access how big the number can be.
When dealing with numbers that are decimals there are three options "Single", "Double" and "Decimal".
Double takes up 8 bytes of memory and can contain a number in the range
4.94065645841247 E-324 to 1.79769313486232 E308
(in scientific notation)