decimal places

[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

 

[Joshua A. Booker]

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]

Thanks for the tip.

Dave

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

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