JFD Art - 8 - Queries using Totals

It is possible to perform calculations in Microsoft Access Queries

Task 1

John would like to know the total value of all his paintings.

Task 2

John would like to know how much stock he holds in English, Welsh etc paintings - Save as "Total Value of Paintings By Nationality"

1  Introduction     2  Setting up tables  3  Inputting Data
4  Creating Relationships  5  Queries - single fields 6 Sorts
7  Queries - Multiple Fields 8  Queries - calculations 9  Forms
10 Reports  11 Graphs