A ariel81 Registered User. Local time Today, 08:17 Joined Dec 31, 2006 Messages 75 Jan 27, 2007 #1 i have a statement like this: Code: rs![tblRecurringDefects] = f("txtTotalRecurring" & i) / f("txtTotalJobs" & i) * 100 how can i have two decimal place?
i have a statement like this: Code: rs![tblRecurringDefects] = f("txtTotalRecurring" & i) / f("txtTotalJobs" & i) * 100 how can i have two decimal place?
RuralGuy AWF VIP Local time Today, 09:17 Joined Jul 2, 2005 Messages 13,819 Jan 27, 2007 #2 Change the [tblRecurringDefects] field from an Integer to a Single or Double floating point number.