numer format

[Mark Kubicki]

this is about the format of a number in a text box on a report...

- what I'm hoping to see is " 7.03 watts" (or what ever the formula (below)
calculates to...)
- what I'm getting is: " 7.0326274854957 " (no: "watts", and too many
decimal places)

my formula for the text box data is:
=Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt] & "watts"

thanks in advance,
mark

 

[Douglas J. Steele]

=Format(Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt], "#.##") & " watts"

 

[fredg]

this is about the format of a number in a text box on a report...

- what I'm hoping to see is " 7.03 watts" (or what ever the formula (below)
calculates to...)
- what I'm getting is: " 7.0326274854957 " (no: "watts", and too many
decimal places)

my formula for the text box data is:
=Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt] & "watts"

thanks in advance,
mark

=Format(Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt] , "#.00") & "
watts"

 

[Douglas J. Steele]

Gee, Fred, you and I both made the same typo, leaving out the same closing
parenthesis! What are the odds?

=Format(Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt]), "#.00") & " watts"


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

this is about the format of a number in a text box on a report...

- what I'm hoping to see is " 7.03 watts" (or what ever the formula
(below)
calculates to...)
- what I'm getting is: " 7.0326274854957 " (no: "watts", and too many
decimal places)

my formula for the text box data is:
=Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt] & "watts"

thanks in advance,
mark

=Format(Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt] , "#.00") & "
watts"

 

[fredg]

Gee, Fred, you and I both made the same typo, leaving out the same closing
parenthesis! What are the odds?

=Format(Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt]), "#.00") & " watts"

Oh oh! Back to the drawing board, Doug.
Your expression above shows 2 open and 3 close parenthesis.

In my original reply, I looked at the parenthesis placement.

Their placement would depend upon what the OP wanted to sum.
Is he summing the result of the multiplications and then dividing that
sum, or summing the result of the multiplications and divisions.

=Sum (A*B)/C
or
= Sum (A*B/C)
or possibly
=Sum ((A*B)/C)

Numbers 1 and 2 will return different answers.
Since multiplication and division can be done in any order, number 3
would result in the same answer as Number 2.

I suspected Number 2 would most likely be better suited but I didn't
want to raise the issue with him as he seemed happy with the math
result (7.032xxxxx) and only wanted to format it.

 

[Douglas J. Steele]

Gee, Fred, you and I both made the same typo, leaving out the same
closing
parenthesis! What are the odds?

=Format(Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt]), "#.00") & " watts"

Oh oh! Back to the drawing board, Doug.
Your expression above shows 2 open and 3 close parenthesis.

Darn, you're right! We were both right the first time after all.