Alan, I hope you're using FMPro 3.0 or higher. I would die a thousand deaths

before using the GetSummary function. I used it when it was first introduced,

but found it to be so -ssssllllooooowwwwww- that it made my database solutions

unusable.

The upgrade to v3 or v4 is *well* worth the price of admission.

There, that said, here's a slightly less cumbersome solution to your problem:

In your database, create a RELATIONSHIP call 'NameMatch' which matchs WITHIN

the current file, name=name.

This will allow you to get rid of the GetSummary Functions and use the MUCH

faster Aggregate functions.

In my example, I have 5 fields as follows:

Name Text - Indexed

Innings Number - Validated by Calc = (Innings = Int(Innings)) or

(Mod(Innings,1) = .1)

or (Mod(innings,1) = .2

calc.InningsWhole Calculation, number = Int(Innings)

calc.InningsPartial Calculation, number = Round(Mod(Innings,1) * 10, 0)

sum.Innings Calculation, number = Sum(NameMatch::calc.InningsWhole) +

Int(Sum(NameMatch::InningsWhole)/3) +

(Mod(Sum(NameMatch::InningsPartial),3)/10)

This works every time, and the validation rule on the innings field keeps the

innings from being entered as 12.25.

One caveat, sometimes the sum.Innings field won't get updated *immediately*

when an Innings value changes. Simply clicking in the sum.Innings field causes

it to update. This solution also eliminates the Partial Inning data entry

field. All innings and partial innings are entered in the Innings field.

Give it a spin, let me know if it works for you.

Quote:

> Ive created a database to track career stats for players in a baseball

> league. Im nearly finished except for displaying the total innings a

> pitcher has completed. I tracks the stats by year and then use the

> sub-summary function to get grand totals for each player in the league. Im

> modeling my database after the Sporting News Baseball Register.

> I use a field to input whole innings and a second field to input one-third

> of an inning completed. The thirds are input as a single digit. The

> display shows the whole innings, a period, then the thirds.

> So a line item of 11 2/3 innings pitched, displays as 11.2 for a one season.

> Another line might read 12.2. Using sub-summary I get a total of 23.4

> innings. On paper I can equate that to 24.1. My goal is to have the

> database display 24.1.

><snip>

--

==========================================================

Michael Little

NOTE: Remove 'PAR3' from my address when replying

==========================================================

no one has to be hip, no one's gotta be out of sight --RD Davies