Access - Calculated Fields
Does anyone know how to do calculated fields based on the results of a query?
I have a car sales database . In the database we have created a multiple table query that displays which cars each sales person has sold.
So if Sales Person 1 has sold 3 cars at £1500 + £2000 + £2532 then I need to add that up into a new field and display it on the report.
I know how to add up different fields, but not how to add up the results of the query - which are all based in different records but the same field.
Any help appreciated.