Number Format Problem (1 Viewer)

[Dezirous]

Hi Experts,

DESCRIPTION:
I am working on a database form with some bound text boxes like HOURS (57), PUNITS (170), SUNITS (49), TUNITS (14), MUNITS, FUNITS, PERUNIT, SALARY, INCOME, SUMFUNITS;
Where MUNITS = (HOURS - 48) * 3 & i.e. (57 - 48) *3 = 27

FUNITS = ((PUNITS+SUNITS+TUNITS+MUNITS) / 48) * HOURS that should be ((170+49+14+27) / 48 ) 57 = 308.75...Point A

PERUNIT = INCOME / SUMFUNIT that should be 102809 / 4570 = 22.4964989...Point B

SALARY = PERUNIT * HOURS 22.4964989 * 57 = 1282.300437...Point C

PROBLEM:
At Point A, my controls are calculating only 308, at Point B it just 22 and at Point C it is only 1282.

REQUIREMENT:
I need decimal value in my controls as describe in red color. Why Access is calculating in lower round figure.

DataEntry, Required, Current Value, Point Of Notice

 

[John Big Booty]

With your table in design view set the Field Size to either Single or Double see this link for further information on the various field sizes.

 

[Dezirous]

Thanks man......... its working............. its so simple.............
Thanks........Thanks...... Thanks.......

 

[Dezirous]

Thanks man......... its working............. its so simple.............
Thanks........Thanks...... Thanks.......