Query Formating

  • Thread starter Thread starter Steve Andler
  • Start date Start date
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
 
Hi Steve,

Use the Format function. e.g:

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

This would give 3 decimal places.

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