Why wont this control show whole numbers?
in [Form]
|
From: love on 20 Mar 2010 17:53 "TonyWilliams via AccessMonster.com" <u56994(a)uwe> wrote in message news:a3e015cb5403b(a)uwe... >I have a control that is based on an expression in a query. This is the > expression: > txtaverage: > IIf([txtNbrPartsOver1]=0,"0",[SumOftxtnbrparts]/[txtNbrPartsOver1] > ) > > I have set the format of the control to 0 decimal places but it still > shows 2 > decimal places not a whole number rounded. > What can I do to force a whole number? > Thanks > Tony > > -- > Why don't my grey cells communicate with each as fast as they used to? I > hate > getting old! > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1 >
From: love on 23 Mar 2010 17:12 "TonyWilliams via AccessMonster.com" <u56994(a)uwe> wrote in message news:a3e015cb5403b(a)uwe... >I have a control that is based on an expression in a query. This is the > expression: > txtaverage: > IIf([txtNbrPartsOver1]=0,"0",[SumOftxtnbrparts]/[txtNbrPartsOver1] > ) > > I have set the format of the control to 0 decimal places but it still > shows 2 > decimal places not a whole number rounded. > What can I do to force a whole number? > Thanks > Tony > > -- > Why don't my grey cells communicate with each as fast as they used to? I > hate > getting old! > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1 >
From: love on 23 Mar 2010 17:31 "TonyWilliams via AccessMonster.com" <u56994(a)uwe> wrote in message news:a3e015cb5403b(a)uwe... >I have a control that is based on an expression in a query. This is the > expression: > txtaverage: > IIf([txtNbrPartsOver1]=0,"0",[SumOftxtnbrparts]/[txtNbrPartsOver1] > ) > > I have set the format of the control to 0 decimal places but it still > shows 2 > decimal places not a whole number rounded. > What can I do to force a whole number? > Thanks > Tony > > -- > Why don't my grey cells communicate with each as fast as they used to? I > hate > getting old! > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1 >
|
Pages: 1 Prev: Outlook Contact Form Full name Next: Problem with sizing Sub Forms on tabbed forms |