numer format

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

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
 
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
Click to expand...

=Format(Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt] , "#.00") & "
watts"
 
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)


fredg said:
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
Click to expand...

=Format(Sum([UnitLoad]*[TotalQuantity])/[TotalSqFt] , "#.00") & "
watts"
Click to expand...
 
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"
Click to expand...

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.
 
fredg said:
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"
Click to expand...

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

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