Topic: Processing

[jcright]

I have a db that I want to do processing on. It has 24 fields each of which will be assigned points based on whether or not the field has been filled in. So, for example, field 1, if it were filled in, would be awarded 4 points and field two, if it were filled in, might be worth 3 points.

Okay, so first I need to check each field and see if it has been filled in. If the field isn't null, then I need to assign that field points.

In the end I'm going to add up the points for each field for a grand total.

Do I use 24 different variables, one for each field, and assign it the points? How do I check to see if a field is null or not? I'm guessing I want something that says:
If <Field 1> is not null
then <variable1> = 4

At the end, I'm guessing that I would want something that says
If
Then <Total Variable> = <variable1> + <variable2> +...+<variable24>

How do I go about doing that?

[Alan]

you could use an array like dim field(24) and the cycle thru it adding up the points based on the field number.