adding a column

[Guest]

New user question.

Using a financial database and want to sum one columns in a query. Just
can't seem to do it. Any help appreciated.

 

[Guest]

You can not sum a column in a query if you want to display other fields at
the same time.
What you can do is sum it in a report. You can also use another query to
sum the column alone and join it in your select query or use a subquery that
does the same thing.

 

[Guest]

Thanks,

Could you provide give me some more detail on how to sum it in a report. I
was able to "sum" it in a query and join the two.

Also, I am trying to select specific items out of the financial statement,
such as fuel charges, and find the total cost of these. I have used advanced
filter to do this, but the "sum" guery gives the total sum not the selected
sum. What's the best way to get the specific items desired and then the costs
associated with those?

Thanks.