Re: Calculating sums in layout with 3 databases

In article <1125205109.327805.210320@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
calder@xxxxxxx wrote:

> Can't remember how to do this and FM Help isn't helping. Thanks for
> you indulgence on this very basic query:
> This is database for a business. The layout in question draws from 3
> databases (Customers, Jobs, Mileage). The layout shows the customers,
> jobs, mileage, wages for a years' time. I want to have a totals of
> wages and mileage appear at the bottom of the layout. What sort of
> field am I creating, do I create it in the Customer or the Jobs or the
> Mileage database and in which part of the layout do I put it?
>
> thanks so much for your help.

That would depend on what you're trying to total (eg. the total of ALL
Mileage, the total of Mileage for each Customer, the total Mileage for
each Job, etc.).

But as a head-start hint, you can use the Sum function via a
relationship link to total all the related records.
eg.
Total Customer Milage {Calculation, Number Result, Unstored}
= Sum (Customer-MileageRelation::Mileage)

This field would be in the Customer file and can be put anywhere you
like on the layout (in the Body part).



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.

Quantcast