Prev: SPECIAL QUERY
Next: Multiple Pivot Charts to display in one page
From: dannie on 10 Feb 2010 12:07
I am sure the answer to this is easy but I cant seem to get it. I need to sum
a few columns.
I have tried using a total query but I dont have anything for it to group
by. I tried putting in a variable like Total:"" but that didnt work. All of
my other queries have had tables which I could LEFT JOIN to create my row
names but now I just want the totals. Thanks for help.
From: KARL DEWEY on 10 Feb 2010 13:11
You can sum without a group by.
--
Build a little, test a little.


"dannie" wrote:

> I am sure the answer to this is easy but I cant seem to get it. I need to sum
> a few columns.
> I have tried using a total query but I dont have anything for it to group
> by. I tried putting in a variable like Total:"" but that didnt work. All of
> my other queries have had tables which I could LEFT JOIN to create my row
> names but now I just want the totals. Thanks for help.
From: John W. Vinson on 10 Feb 2010 13:17
On Wed, 10 Feb 2010 09:07:02 -0800, dannie <dannie(a)discussions.microsoft.com>
wrote:

>I am sure the answer to this is easy but I cant seem to get it. I need to sum
>a few columns.
>I have tried using a total query but I dont have anything for it to group
>by. I tried putting in a variable like Total:"" but that didnt work. All of
>my other queries have had tables which I could LEFT JOIN to create my row
>names but now I just want the totals. Thanks for help.

Dannie, it's more than a bit difficult to help you here: you haven't posted
anything about the structure of your table or what it is that you want to
total.

Give us some help please?
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: SPECIAL QUERY
Next: Multiple Pivot Charts to display in one page