Hello Chaps - Please explain which format and field size to use in the following situation.
I have a table with records recording sizes in mm.The sizes recorded are unlikely to exceed
2000 mm and will always only have one decimal point ( for example 101.6 mm or 25.4 mm or
1995.7mm)
These sizes are later used in calculations of mass,volume area ( so it could be 101.6 * 3.1416(
which gives circumference)) The result of the calculation will always be rounded to one decimal
now i am puzzled do i use format fixed,standard or general number ??
which field size do i need to select - long integer,single, double or decimal ??
Your time and effort is much appreciated
Best regards
Fred from south africa ( its nice and warm in Johannesburg today)