Query Formating

[Steve Andler]

Hi ;

I am sure that's very basic question .
How do we format columns in queries ?
I want it to show the same number of digit after dot .

Thanks in advance

Steve

 

[Glenn]

Hi Steve,

Use the Format function. e.g:

Expr1: Format([Field Name],"0.000")

This would give 3 decimal places.

Glenn

 

[Van T. Dinh]

Right-click on the required Column and select Properties. Specify the
required format in the "Format" Properties in the Properties window.