Re: Calculations in Report...

Can't you just place
=(Sum([TotalPaid])+Sum([TotalComped])+Sum([TotalAddGsts])+Sum([TotalKids]))
in a Month group footer?


--
Duane Hookom
MS Access MVP

"Matt" <Matt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F0EC11ED-0BB4-4F9E-95C1-7B6D79514691@xxxxxxxxxxxxxxxx
I am having difficulties with a calculation in my report.

What I currently have is a range report that calculates number of covers
in
a restaurant on a month to month basis, this in turn makes some
calculations
with cost and revenue. When I due a date range for any given month, the
calculations work great. However, when I want to do a range for a two
month
period (i.e. 06/01/06-07/31/06). The months remain separated so we can
view
the comparison, however the one field that does the total covers
calculation
now shows the total for both months together, which obviously scews the
cost
per person analysis for both months.

PLEASE HELP! I am sure there is something wrong with the control source
expression I currently have which is as follows:

=(Sum([TotalPaid])+Sum([TotalComped])+Sum([TotalAddGsts])+Sum([TotalKids]))

But when I try to alter it to this:
=[TotalPaid]+[TotalComped]+[TotalAddGsts]+[TotalKids]

this expression just places all the numbers in a long string (eg. June 06
should read 4325 covers, instead it strings 3539404250132. Which is for
3539
Paid, 404 Comped, 250 Additional Gsts, and 132 Kids.)

Any suggestions? Sorry for the long questions, I just wanted to give you
the
best idea of what I'm doing.

Thanks



.

Relevant Pages

  • Re: ENGLISH!
    ... Government policy is therefore blown off course by the views of an aggregate of lazy-minded people who cannot be arsed to learn anything new, and who are encouraged to remain in that state of lazy-mindedness by their low-quality newspapers. ... In the UK a longer time was allowed for the transition, ... Now that I think of it, there was one extra cost for me of having a dual ... engineering student at the time that electrical engineering calculations ...
    (alt.usage.english)
  • RE: EV Formulas
    ... We don't use these fields for real earned value but here are the calculations: ... actual duration, or percentage of work complete), Microsoft Project ... ACWP: When a task is first created, ... Microsoft Project calculates the actual cost of work performed. ...
    (microsoft.public.project)
  • Re: EV Formulas
    ... > Budgeted cost of work scheduled ... > Description The ACWP field shows costs ... > resources' Standard Rate, Overtime Rate, Per Use Cost, and Cost accrual ... the calculations are based on progress (percentage ...
    (microsoft.public.project)
  • Re: Calculating project completion %
    ... I don't see any reason not to use the definitions and calculations ... Project planning and tracking is about Cost. ... WHAT WOULD BE THE SOLUTION FOR CALCULATING PROJECT COMPLETION % ... Now lets think of a slightly different scenario: ...
    (microsoft.public.project)
  • RE: Cashflow
    ... Can we agree that we cannot perform these calculations until we either have ... firm values for the total duration and expenses - either planned or actuals? ... Produce a set of cashflow data for a construction project - ... 10% period; 5% cost ...
    (microsoft.public.excel.misc)