Creating a column total

[emcc]

I'm still working on my report...now I've moved on to column totals. For the columns that refer to a table the totals come off with no problem. The one column that is a "derived" total is another story. When I use the expression =sum([Outstanding])a message box pops up asking for a parameter value for Outstanding. I can't seem to figure this one out. This report is nothing fancy - no subtotals or groupings - so this would be just a straight total.

Has anyone come across this before?

 

[SomeGuy]

Dumb Question: Are you positive that the Outstanding is the name of the dervied field that you are asking to sum.

I have had it do that to me as well but it was because I had typed the name wrong and it want to know where to get its source from.

 

[Rich@ITTC]

Hi emcc

You will probably have to reference the complete calculation that Outstanding is based upon.

If your calculated field - Outstanding - is based say on two fields (Cost and Received) then your total will call upon them eg:

=Sum([Cost]-[Received]).

If these values are on a subreport, then the full name will need to be referenced - eg:

=Sum(Reports!MyMainReport!MySubReport.[Cost]-Reports!MyMainReport!MySubReport.[Paid])

HTH

Rich

[This message has been edited by Rich@ITTC (edited 12-19-2000).]

[This message has been edited by Rich@ITTC (edited 12-19-2000).]

 

[emcc]

Rich and SomeGuy-

Thank you both for your help on this. It was actually Rich's solution that worked! Access, it seems, is a bit quirky that way but now that I know how it thinks I should be able to avoid these kind of problems in the future.

emcc

 

[emcc]

Rich and SomeGuy-

Thank you both for your help on this. It was actually Rich's solution that worked! Access, it seems, is a bit quirky that way but now that I know how it thinks I should be able to avoid these kind of problems in the future.

emcc