I have a calculation that does not seems to work, I need to get some help with. I pasted the calculation below, what is going wrong is it shows Division 1 and i have 249 Points in the sumary Field.

Case(GetAsNumber(Total Point Joint) ≤ 59; "Division 5";

GetAsNumber(Total Point Joint) ≤ 179; "Division 4";

GetAsNumber(Total Point Joint) ≤ 259 and GetAsNumber(varsityGame) ≥ 40; "Division 3";

GetAsNumber(Total Point Joint) ≤ 559 and GetAsNumber(varsityGame) ≥ 75; "Division 2"; "Division 1"

)

thanks in advance.

Randy

Works OK for me.

You mention "sumary" field - what is this a summary field of?

the Summary field is the Total Point Joint it is numbers.

Also I defined a new relationship in my table that is the sum of all the point in a point field.

That is the Summary field, It is not a summary as far as the database field defination as a summary.

Edited September 4, 200916 yr by Guest
do not repeat a post just to add a part

What it continues to show is Division 1 could there be something in the field causing the error.

It would be nice to see your file, because I'm not sure what else is effecting your outcome, and I'm not sure that I'm understanding what the fields are suppose to have in them, however, if you change your last line of code from "Division 2"; "Division 1" to "Division 1"; "Division 2" and it seems to solve the problem.

Lee

give me an email address and I will send it to you.

Please do not send me a file off list. Instead, you can attach a file here in a Reply to your Thread. For directions on how to attach a file, see this recent post. Link

Sending a file off list will limits the possible solutions to one person, and you are at the mercy of their work load. Also, this is a learning Forum, and by sharing your problem, and any solutions you receive, can help other in the future with similar problems.

Lee

On the file Click on the file and hold option key the username is Randy Koonce and there is no password.