how to write calculation in a access query

[remy]

How would you write in a query this calculation.
sum of (requested)-(services)-(cost)
I know how to produce this formula in excel but not in an access query.

 

[HiTechCoach]

One option would be to use a totaling query.

If printing the data on a report, you may want to use the report to do the summing.

 

[giovaanni]

Just do the math in your query as an expression field and then aggregate that column as a sum.