View Full Version : Field expression (CALC field)


Ludwig Beil
07-13-2000, 10:33 AM
calculated fields (restrictions)

Hallo, out there!
I try to build a little application for our school, which handles the results and places points on the screen.

What I have:
a set, which shows the points for certain results(jump, run...) on the form and add the points.

My problem:
I want to show on the form in a calculated field, whether the athlet gets a winner (W) or a special(S) sheet.

I tried to build an expression with two IFs and failed.....
I started like this:

Robert Picard
07-13-2000, 09:09 PM
Hi Ludwig

Could you be more clear when you say the expressions failed.

Did you get an error message? Or did they evaluate but gave the wrong result.



Ludwig Beil
07-23-2000, 06:54 AM
thanks for your help. I found a solution for my problem.

Barry Jackson
07-24-2000, 08:59 AM
I tried your expressions on our Alpha4 V6 and they worked fine. What do you mean by failed ?.
They were certainly accpetable to Alpha.
Perhaps you would like to e*mail a very small portion
of your database and test data - and indicate why you think there is an error.

Ludwig Beil
07-25-2000, 12:57 PM
thanks for your offer, I found a solution two days ago.
Ive been building scripts and apps the hard way and thought I was an expert but after not programming for a year with a4 you have to start again learning......