[Guy]

I have a field in my report that I want to sum up in a footer but it will not let me. I named a field named [Regular] which has [Cost] * [Overhead] * [Taxes] as its control source (from a query). In the footer I have =Sum([Regular]) but when I run the report it keeps asking for [Regular].

Can this be done, or am I wasting my time?

- Guy

[Edited by Guy on 05-02-2001 at 11:10 AM]

[downwitchyobadself]

It sure can, and in lots of different ways. There's just one thing I don't understand in your post: is the field in the underlying query called CostConv? Or is the control on the report called CostConv? And what's regular?

In any case, if you're summing in the report's query, let's say, you have a field called SumWithTax, which is the result of the calculation cost*overhead*tax. Then you can put in the footer control a control source of =Sum(SumWithTax). But if you're calculating in the control on the report, i.e. your control source reads something like

=[MyCost]*[MyOverhead]*[MyTaxes]

or however you're working it, then your sum needs to match it:

=Sum([MyCost]*[MyOverhead]*[MyTaxes])

I'm assuming that you've told it to sum the control, which is not quite the same thing; only controls' data can be totaled.

Otherwise, check out the RunningSum property in Access help, and so on, for other possibilities.

Hope this helps.

[Guy]

Sorry, I used 2 different names for the same thing. Okay, I have a query with 2 fields: Cost and Hours. In my report I have 2 text boxes: Hours and Cost. If I put in my footer =Sum([Hours]) and =Sum([Cost]) then I get the totals that I want.

But, if I name one of the text boxes to 'CostPlus', for example, and In the text box I have [Cost]*13.5 as the control source. Then I put =Sum([CostPlus]) in the footer, i get prompted to input CostPlus when I run the report.

What you are saying is that I have to put =Sum([Cost]*13.5) in my footer, correct? Is there anyway to get around this (Ive tried doing my calculations in a query but I gave up on that)?

[downwitchyobadself]

The way to get around it is to do your calculations in your query. When you tell Access to do a sum, it assumes you mean a sum of a field; a control is a shell around data, not data itself, if that makes sense.

But if you add, in a new column in the query, the following text

CostPlus: [Cost]*13.5

then save the query, you'll get a field called CostPlus, and you can then put =Sum([CostPlus]) for the control source of the report footer control.

There is no way "around" it because you're confusing report (or form, for that matter) controls with data fields.

[Guy]

I got it now by doing my calculations in a query. Thanks.