formatting decimal places

[fishqqq]

I have a text field that i've set the control property as follows:

=Sum([QTY]) & " pcs - " & " " & [Lock HazStatus] & " at " & [Text10] &
" kgs Actual Wgt"

which returns

6 pcs - Haz at 544.307983398438 kgs Actual Wgt

Is there a way to format the [Text10] value to 2 decimal places?

thank you
Steve

 

[John W. Vinson]

I have a text field that i've set the control property as follows:

=Sum([QTY]) & " pcs - " & " " & [Lock HazStatus] & " at " & [Text10] &
" kgs Actual Wgt"

which returns

6 pcs - Haz at 544.307983398438 kgs Actual Wgt

Is there a way to format the [Text10] value to 2 decimal places?

thank you
Steve

Sure: a couple. Probably simplest is

=Sum([QTY]) & " pcs - " & [Lock HazStatus] & " at " & Round([Text10],2) & "
kgs Actual Wgt"
--

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 also http://www.utteraccess.com

 

[fishqqq]

I have a text field that i've set the control property as follows:

=Sum([QTY]) & " pcs - " & " " & [Lock HazStatus] & " at " & [Text10] &
" kgs Actual Wgt"

which returns

6 pcs -  Haz at 544.307983398438 kgs Actual Wgt

Is there a way to format the [Text10] value to 2 decimal places?

thank you
Steve

Sure: a couple. Probably simplest is

=Sum([QTY]) & " pcs -  " & [Lock HazStatus] & " at " & Round([Text10],2) & "
kgs Actual Wgt"
--

             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

thank you John