Can someone tell me how to get a number value in a field to round up
as follows:
user inputs 18.333
format rounds up to 18.50
user inputs 18.222
format rounds to 18.00
thanks
Steve
Can someone tell me how to get a number value in a field to round up
as follows:user inputs 18.333
format rounds up to 18.50user inputs 18.222
format rounds to 18.00thanks
Steve
To round to the nearest .5, multiply by 2, round to an integer, and divide by
2:
Round(2*[field], 0)/2
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see alsohttp://www.utteraccess.com
Can someone tell me how to get a number value in a field to round up
as follows:user inputs 18.333
format rounds up to 18.50user inputs 18.222
format rounds to 18.00thanks
Steve
To round to the nearest .5, multiply by 2, round to an integer, and divide by
2:
Round(2*[field], 0)/2
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see alsohttp://www.utteraccess.com
To round to the nearest .5, multiply by 2, round to an integer, and divide by
2:Round(2*[field], 0)/2
--John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see alsohttp://www.utteraccess.com
I just got around to trying to make this work and i'm a little lost.
can you please tell me if I'm supposed to place the format "
Round(2*[field], 0)/2 " in the field's format property?
when I try this Access reformats it as follows:
this... Round(2*[Wgt Lbs], 0)/2 (note Wgt Lbs
is the field name)
turns to this ... "Rou"nd"(2"*[w"gt Lb"s"], 0)"/\2
Can you please tell me what i'm doing wrong?
thank you
I just got around to trying to make this work and i'm a little lost.
can you please tell me if I'm supposed to place the format "
Round(2*[field], 0)/2 " in the field's format property?
when I try this Access reformats it as follows:
this... Round(2*[Wgt Lbs], 0)/2 (note Wgt Lbs
is the field name)
turns to this ... "Rou"nd"(2"*[w"gt Lb"s"], 0)"/\2
Can you please tell me what i'm doing wrong?
thank you
I just got around to trying to make this work and i'm a little lost.
can you please tell me if I'm supposed to place the format "
Round(2*[field], 0)/2 " in the field's format property?
when I try this Access reformats it as follows:this... Round(2*[Wgt Lbs], 0)/2 (note Wgt Lbs
is the field name)
turns to this ... "Rou"nd"(2"*[w"gt Lb"s"], 0)"/\2Can you please tell me what i'm doing wrong?
thank you
What you're doing wrong is using the Format property. Format doesn't change
the value of a field (from 3.28 to 3.5 for example); it only changes how the
field is displayed.
My suggestion was to create an Expression taking one value and returning a
different value; this expression can be used as a calculated field by putting
it in a vacant Field cell in a Query, or as the control source of a form or
report textbox.
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see alsohttp://www.utteraccess.com
John, if i want this rounding to change how the field is displayed
would I put your expression in the format of the unbound textbox?
You wouldn't put it in the Format period.
The Format is INCAPABLE OF DOING WHAT YOU WANT.
You're barking up the wrong tree!
Put the expression - preceded by an = sign - in the Control Source of the
textbox instead.
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see alsohttp://www.utteraccess.com