Want to round the left side of the decimal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a situation whereby the query produces a result like this $11,474,580
and I want it to view in my query or report $11.4 million.. Can someone help
me with this.. Need help right away for a deadline.

Thanks
 
i take it that the issue is you don't want the calculated value to round,
such as $11,474,580 = $11.5 million.

try adding the following calculated field to your query, as

ValInMils: Format(([NumberValue]-Right([NumberValue],5))/1000000, "0.0")

hth
 
Thanks Tina, if I wanted it to round and as you suggested $11,474,580 = $11.5
million how would that be written..

tina said:
i take it that the issue is you don't want the calculated value to round,
such as $11,474,580 = $11.5 million.

try adding the following calculated field to your query, as

ValInMils: Format(([NumberValue]-Right([NumberValue],5))/1000000, "0.0")

hth


Rick said:
I have a situation whereby the query produces a result like this $11,474,580
and I want it to view in my query or report $11.4 million.. Can someone help
me with this.. Need help right away for a deadline.

Thanks
Click to expand...
Click to expand...
 
ValInMils: Format([NumberValue]/1000000, "0.0")

hth


Rick said:
Thanks Tina, if I wanted it to round and as you suggested $11,474,580 = $11.5
million how would that be written..

tina said:
i take it that the issue is you don't want the calculated value to round,
such as $11,474,580 = $11.5 million.

try adding the following calculated field to your query, as

ValInMils: Format(([NumberValue]-Right([NumberValue],5))/1000000, "0.0")

hth


Rick said:
I have a situation whereby the query produces a result like this $11,474,580
and I want it to view in my query or report $11.4 million.. Can
Click to expand...
someone
help
me with this.. Need help right away for a deadline.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top