Changing total cell to expression (1 Viewer)

[icemac]

When i use MS Access help to search for my query i get this result:

"Note: If you add a calculated field that includes one or more aggregate functions to a query in qhich you're calculating totals on all the records, you muct set the calculated filed's TOTAL cell to EXPRESSION

How do i do this?????

 

[wardster]

on the toolbar click Σ which then adds the grouping to the query, using the dropdowns select "Expression" for the field you are calculating the sum for.

Ian