AnsweredAssumed Answered

Accummulating totals in a summary field  with two sub summary elements

Question asked by PecCars on Feb 20, 2011
Latest reply on Feb 21, 2011 by philmodjunk

Title

Accummulating totals in a summary field  with two sub summary elements

Post

Consider the the table TA with TA::PropertyId, TA::Year, TA::Stays. You can have several properties in several years. You will have one record per stay. Now ... I need a summary by property and year. I have also decided to do this at the table level instead of using a layout. The reason being those stats and others are the basis for my reports, but are not the reports themselves.

TA will be sorted by PropertyID and by Year. I can total the stays in TA::AccummulatedStays by property for instance: create a summary field TA::AccummulatedStays; Total it as running with restart when sorted by TA::PropertyID. Works ... now

How do I tell it to break and restart when the year changes ?

Outcomes