decimal places

  • Thread starter Thread starter David Shorthouse
  • Start date Start date
D

David Shorthouse

Hello gurus,

I have built a concatenation query from two number fields, each of which
have several more decimal places than what I need. Is there any way to
specify the number of decimal places in the query (i.e. in the expression
builder) whose result is a text field?

Thanks for any advice,

David
 
David,

If you want text data as a result try using the Format function like this:

Result: Format([Data],"0.00")

Where Result is the name of the resulting field and Data is the file you
wish to apply decimals to. This will drop the extra decimals and mat even
round as if it were anumber, but will return a string (text). You should
use math functions such as Round or RoundUp if you wish to round numbers
properly.

HTH,
Josh
 
Thanks for the tip.

Dave

Joshua A. Booker said:
David,

If you want text data as a result try using the Format function like this:

Result: Format([Data],"0.00")

Where Result is the name of the resulting field and Data is the file you
wish to apply decimals to. This will drop the extra decimals and mat even
round as if it were anumber, but will return a string (text). You should
use math functions such as Round or RoundUp if you wish to round numbers
properly.

HTH,
Josh

David Shorthouse said:
Hello gurus,

I have built a concatenation query from two number fields, each of which
have several more decimal places than what I need. Is there any way to
specify the number of decimal places in the query (i.e. in the expression
builder) whose result is a text field?

Thanks for any advice,

David
Click to expand...
Click to expand...
 
Back
Top