Summing a field in an Access table and displaying the total

Question

How do I sum a column in Access 2010 and display the total in a new column (using expression builder perhaps)?

Answer 1

It's generally a bad idea to store a calculated value in a table. If you need a calculated value, calculate it when you are displaying it. Generally this is done in a report or on a form.

There are exceptions to this, but it sounds like you would be best served by displaying the calculated field in a report/form and not in your table.

Answer 2

SELECT SUM(num_fld) as Sum_Nums FROM your_table WHERE num_fld > 5;

I don't know about expression builder but this query works