Total a calculated field in a query

[chablups]

I have a query in which I have a calculated field. Lets just say it is [A]+.
I want to total all the records for that field, so I click on the total button on the tool bar and I get the Total Cell. So I read help and it tells me that if I have a calcuated field I must click on "expression" for the total cell, which I did, and the word "expression" fills the cell. My question is this: where do I put my expression AND how do I write it? So first, where do I enter the expression, and second, how do I write it, is it like this: =Sum[A]+. ?? Thanks.

 

[RichO]

In the field box enter =Sum([A] + )

This query only returns one result and that's the sum of those 2 fields. You are not able to display additional fields from the source table along with this sum. You'll get an error if you try to do that.

 

[chablups]

So you mean I can't get there from here ...

I'm sorry, maybe I didn't make myself clear, or maybe I'm just not understanding you... I'm not trying to get a sum of two fields in the same record. What I am trying to do is this: I have let's say twenty records. There is a field in my query which is a sum of several numbers. Like a+b+c+d which come from my table. I am trying to total the totals for the twenty records, to arrive at a grand total. Is there no way to do that? Thanks.