Field Properties: Decimal Places - DOES NOT WORK!!!

R

Richard

Hi,

I made a query. Some of the fields are Expressions; one of them:

SumOfFieldA / SumOfFieldB as FieldC

I need the expression result just as an integer, i.e. with no decimal
places. I changed in the Design View the properties of the field - Decimal
Places to "0".

However, I run the query, numbers in the fields are in full view (with 10-12
decimal places).

Can somebody help, please?

Thank you in advance.

Richard
 
N

Nikos Yannacopoulos

Richard,

Have you specified a format? The decimal places property will be imposed
only if an appropriate format is specified. Select Fixed for no thousand
separators, or Standard to include decimal separators.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make elements in a row space between instead of wrapping when choosing multiple columns 0
How to Reduce Decimal Places? 2
Number of decimal places output 8
Too many decimal places in Pie Chart 1
Restrict percents so they will not show decimal (i.e. 61% not 61.2 1
Using the format function for a percent with four decimal places 5
dropdown decimal places 7
Format query result as Data Type Number, Field Size Decimal 3

Top