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

G

Guest

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

Access stripping decimal places in query 1
Too many decimal places in Pie Chart 1
Decimal places in calculated fields 6
Format query result as Data Type Number, Field Size Decimal 3
query field help 1
dropdown decimal places 4
How to Reduce Decimal Places? 2
Number of decimal places output 8

Top