How to Access Sum Columns

In Microsoft Access, you can sum, or add, data together by a query. Queries allow you to sum data based on a condition, such as by the table position. You can use the sum command on data arranged in columns. This function gives you access to query table data that use various column numbers.

Instructions

1. Click "Start," type "office access" and then press "Enter" when the program name appears in the search results.

2. Press "Ctrl"+"O." Locate, select and open an Access database that contains a table in it.

3. Click "Create" in the ribbon, then click "Query Design" in the "Other" group.

4. Double-click the table you wish to access for the columns sum. The table will then be highlighted to show that it has been selected. Click "Close" to confirm the selection.

5. Click "Run." This opens the column's sum access. Click "Save" to save the query to use.

References

• Microsoft: Sum data by using a Total row