calculated controls on reports

[laurie]

I have a query where the "gallons" field is a calculated
control. In the design of the query, in the Total Row I
have that field marked "sum" so it totals all of one
stain color in the same month. When I go to the report
for this, I can not get the report to pull that field -
the "Gallons" field - or as the text box properties
control source refers to it as "SumOfGallons".

First, how can I get the figures that were calculated in
my query to show up in my report?

Anyone's help would be appreciated! Thanks!

 

[Fons Ponsioen]

Hi Laurie.
First I do not understand that you could not display any
field from a source query in your report. Than, if you
intend to use the summing in the report footer it is
usually best to simply use <= sum([Gallons])> rather than
try to calculate this in the query.
Post back with some more specific detail if this did not
help.
Fons