Showing three decimail places in a query

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

Hi,
Hope you can help me with this. Normally when I want to
show a number like .25 as .250 I just format it as fixed
in the report. Unfortunately in this instance I can't do
this because I'm building a long text string based on a
fairly complicated if statement within the query. The
problem is I can't figure out how to format a number
like .25 to be .250 . I always want three decimal
places. I tried round but that doesn't work. I noticed a
command called FIX but it just sets it to zero, and I
can't find anything that describes the FIX function! Any
ideas.
Thanks!
 
Gina said:
Hi,
Hope you can help me with this. Normally when I want to
show a number like .25 as .250 I just format it as fixed
in the report. Unfortunately in this instance I can't do
this because I'm building a long text string based on a
fairly complicated if statement within the query. The
problem is I can't figure out how to format a number
like .25 to be .250 . I always want three decimal
places. I tried round but that doesn't work. I noticed a
command called FIX but it just sets it to zero, and I
can't find anything that describes the FIX function! Any
ideas.
Click to expand...

Format([YourField],"#.000")

That will return a string representation in the format you want, but if you're
using it to build up a larger string it should work for you.
 
THANKS SO MUCH...worked like a charm :)
-----Original Message-----
Gina said:
Hi,
Hope you can help me with this. Normally when I want to
show a number like .25 as .250 I just format it as fixed
in the report. Unfortunately in this instance I can't do
this because I'm building a long text string based on a
fairly complicated if statement within the query. The
problem is I can't figure out how to format a number
like .25 to be .250 . I always want three decimal
places. I tried round but that doesn't work. I noticed a
command called FIX but it just sets it to zero, and I
can't find anything that describes the FIX function! Any
ideas.
Click to expand...

Format([YourField],"#.000")

That will return a string representation in the format you want, but if you're
using it to build up a larger string it should work for you.


.
Click to expand...
 
Back
Top