Query Formating

S

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
 
G

Glenn

Hi Steve,

Use the Format function. e.g:

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

This would give 3 decimal places.

Glenn
 
V

Van T. Dinh

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