syntax?

[Guest]

I have two columns in a report that I need to divide the results. I have a
column named New and it is summed up at the bottom of the column. The other
column is called Days Worked. It is also summed up at the bottom. What would
be the expression to divide the cum of new and the sum of the days worked?

 

[Guest]

=((Sum([SomeColumn]))+(Sum([AnotherColumn]))

 

[Guest]

=[sumoffield1]/[sumoffield2]

I think that that's what Wayne meant but he 'summed' it up again.

hth

 

[Arvin Meyer [MVP]]

I am assuming that the totals are in a footer. Create a textbox in the
footer and set it's controlsource to:

= Sum([New]) / Sum([Days Worked])

If your control names are different, make the appropriate substitutions.

 

[Guest]

ooops

ok - I promised last year but this year I "will" make a new year resolution
to read posts more carefully.

Drock-13 ignor my "sum" and use Maurice's "division"


--
Wayne
Manchester, England.

=[sumoffield1]/[sumoffield2]

I think that that's what Wayne meant but he 'summed' it up again.

hth
--
Maurice Ausum

I have two columns in a report that I need to divide the results. I have a
column named New and it is summed up at the bottom of the column. The other
column is called Days Worked. It is also summed up at the bottom. What would
be the expression to divide the cum of new and the sum of the days worked?

 

[Guest]

Thanks for the help!
--
Drock-13

I am assuming that the totals are in a footer. Create a textbox in the
footer and set it's controlsource to:

= Sum([New]) / Sum([Days Worked])

If your control names are different, make the appropriate substitutions.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I have two columns in a report that I need to divide the results. I have a
column named New and it is summed up at the bottom of the column. The
other
column is called Days Worked. It is also summed up at the bottom. What
would
be the expression to divide the cum of new and the sum of the days worked?