Totaling in Access 2000

[kbfnet]

Hello!

I ran a query that gave me back a column with two rows of data in it just like the following

50
25

How do I get the two rows in one column to total so that it says 75?

Thank you,
Kbfnet

 

[bernie10]

SELECT Sum(YourTable.YourField) AS SumOfYourField
FROM YourTable;

HTH,
Collen

 

[kbfnet]

Hi Collen,

Do you mean to Sum as an expression? Or, to use Sum as a grouping. Its not giving me the total if I Sum as a grouping.

I realize that I am being dense but I am having a brain meltdown with this issue!

Thanks,
Kbfnet

 

[bernie10]

Hi kbfnet,
I guess I'm not understanding your question. I was thinking your issue was straightforward and that you simply had a table of a couple of values and that you wanted those totaled in a query.

Perhaps one of the "true" experts can follow your questions better than I and offer some help.

Collen

 

[kbfnet]

Hi Collen,

Sorry. I got it. I was being silly. Thanks again for your help!

Thanks,
Kbfnet