Limit Decimal Places in Function
- From: "tminn" <tminn@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 13 May 2005 15:09:01 -0700
I have a report that shows (in part) the average length of time it took
participants to graduate from a program in both days and months. In the
query I have set both of the Average fields (days and months) to "Format:
Fixed" and "Decimal Places: 1". The problem is, however, that when I
generate the report, I have the months text box Control Source set to:
=[AvgOfMonths] & " Months"
[AvgOfMonths] is obviously the number, and then " Months" is the text I
want to appear afterwards. The problem is, I can't get the numerical part to
limit itself to one decimal place. I've set the months text box in the
Report to "Format: Fixed" and "Decimal Places: 1" as well, but that doesn't
seem to work (I assume due to the text that follows it in the control source.
Any ideas on how to limit the number of decimal places??
.
- Follow-Ups:
- Re: Limit Decimal Places in Function
- From: Steve Schapel
- Re: Limit Decimal Places in Function
- Prev by Date: Re: Need Help with Stephen Lebans "justification" code used with sub-sub-forms
- Next by Date: RE: Open a different form at startup
- Previous by thread: View ComboBox List
- Next by thread: Re: Limit Decimal Places in Function
- Index(es):
Relevant Pages
|
