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.
 
You must log in or register to reply here.

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

Checking if data exists another table and, if yes, extracting a value 0
Finding and naming duplicates 4
Make-table query with around 2 ml records taking too long 0
Using a period or dot in a parameter query criteria line 2
Enter a dot between numbers 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Parmeters 2
Pie Chart 1

Back
Top