How to Format Numbers Within a Query on Access 2003


Access 2003 queries provide functionality in the database. They allow you to question and analyze your data in a customized fashion. When creating a query, you can select the tables, queries and fields that you want displayed in the query result. The query result may not be formatted in the desired format, but this can be resolved by utilizing the format properties. Depending on the field, there are several different field properties available to customize your query results.

  • Open Access 2003, and then click the "File" drop-down menu. Select "Open." Browse the files and locate the database. Click the database followed by the "Open" button. The database prompt appears. Select "Open."

  • Click the "Queries" button in the "Objects" pane. Select a query, and then click the "Design" button on the query toolbar.

  • Select the field that has numbers that need number formatting. Click the "Properties" button on the standard toolbar. Click the drop-down list in the "Format" column on the "General" tab. Select the number formatting you will use. If necessary, specify the decimal places using the "Decimal Places" drop-down field. Click the "X" button to close the "Properties" box.

  • Review the number formatting by clicking the red "!" button on the standard toolbar. The query result is displayed in the query datasheet view.

    If the formatting is incorrect, click the "View" button and then select "Design View." Click the field where the formatting was applied, and verify that the correct number format was selected.

Related Searches


Promoted By Zergnet



You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!