Re: Sum Calculated fields on Continuous form

Tech-Archive recommends: Fix windows errors by optimizing your registry

No, the subtotal returned is based on the week ending date on the sub form
and doesn't change when moving from the current record.

I can't create the calculated field in the query in the continuous form as
it uses the dates returned in the query for the continuous form to calculate
the subtotals in the continuous form DSum field.

I don't know if this is making sense but it won't work to do as Wayne
advised. Any other suggestions???

Thanks

Sonya


"Wayne Morgan" wrote:

I suspect that if you check, the subtotal that is returned is for the
current record. If you move to the next record, all of the subtotals will
update to show the subtotal for the next record.

To do what you're asking, you need to create the subtotals in the query
feeding the continuous form using a calculated field in the query. This will
give you a field to bind the subtotal control to so that it will be
different for each record. You will also then be able to do a sum on this
field in the form's footer.

--
Wayne Morgan
MS Access MVP


"SL" <SL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DE5FD6C0-7CD3-4E25-88C1-048DC65F753C@xxxxxxxxxxxxxxxx
Morning All

I really hope someone can help with this as its driving me mad!!

I have a continuous form which contains all week ending dates returned
from
the query and the sub total for each week - the sub total is calculated
using
=DSum("PltTotal","Union_PrevPltDtl"). This is taking the total from
another
query, which uses the week ending date returned on this subform to
calculate
the correct total. The sub totals returned are correct.

My problem is I need to show a total in the footer of the form of all the
sub totals and I can't seem to do it. If I Sum the calculation above in
the
footer all it does is multiply the 1st total returned by the number of
records returned. I have tried various options and can't get the total
correct. Basically I need to add all totals on the subform but because
they
are calculated fields based on the w/e date I can't.

Any help would be most appreciated.

Thank You

Regards

Sonya



.

Relevant Pages