Summing: you can use a separate summation query. If for some reason you must do this in the same query, you could then pull the summing query up with the original as a new query. BUT: this would give you your sum, but it would be listed in every record. <br>
It might be possible to slap a sum function together to get your total. BUT: This might lead to the same effect as above.