Successive records in same layout give different results

[steveob]

Hi

Hope someone can help with this problem. Running FP6. I run a large junior golf tournament at various venues. One file holds player details, their names, scores etc. A second file is used solely to calculate the CSS (Competition Scratch Score). It is this file that is causing me problems. There is only one layout with 16 records, one for each venue.

I input the number of players in two different ability categories. One field then calculates the percentage of each category in relation to the total number to the nearest 10%. At the end of the tournament, the main database gives me the number of players who have made a"qualifying score". This number is then put in to the calculation file and a calculation is made as to whether the CSS differs form the SSS (Standard Scratch Score) and by how many. There are only six possible options, -1, 0, +1, +2, +3 and +3 Reduction Only.

For fourteen or so of the records, this works perfectly but for the other two, instead of a number I get "call andy", Andy being the person, before my time, who devised the original files. I suspect that he inserted this in to the field at the end of the calculation because he could not find a way to include the "-1" in the calculation.

I know that a number should be there as it is possible to do a manual check.

All fields are exactly the same for each record. Can anybody suggest why two are behaving in this unusual way?

Hope the above makes sense and any suggestions gratefully received.

[bcooney]

Oh, that's rich, "call Andy." Why didn't I think of that, except I'd put "Call comment!"

Seriously, if you'd detail your calculations, I think others will chime in with suggestions.