adding a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jd - 28 Apr 2006 23:31 GMT

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.

Reply to this Message

KARL DEWEY - 28 Apr 2006 23:53 GMT

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.

> 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.

Reply to this Message

jd - 30 Apr 2006 13:59 GMT

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.

> You can not sum a column in a query if you want to display other fields at
> the same time.
[quoted text clipped - 6 lines]
> > Using a financial database and want to sum one columns in a query. Just
> > can't seem to do it. Any help appreciated.

Reply to this Message