Find Script

[faaslave]

Hello all,

I am trying to script a find but I think that I am not doing it the most efficient way.

I have a field that can have eight different values, A, B, C, D, E, x-A, x-B, and x-C

The other field is a date field.

I want a script that says, find records with A or B or C and the criteria in the line below

And in the date field I want >=7/1/2011 and =(if the field is blank)

How can I make a simple script to do this? I can only do it with many steps.

Thanks Dave

[comment]

I have a field that can have eight different values, A, B, C, D, E, x-A, x-B, and x-C

Do you mean it can have one of the eight values?

And in the date field I want >=7/1/2011 and =(if the field is blank)

I don't know what you mean by that.

[faaslave]

Yes, field one can only have one value. Field two is a date field

So the find should be something like:

(Field1 = A, B, or C) and (field2 = any date greater than 7/1/2011 or no value)

[comment]

You need multiple requests for each OR find. In order to avoid generating every possible combination of your criteria, I would start by finding A, B, or C in the first field (three requests), then constrain the found set by two more requests.

Where do the values A, B, C and 7/1/2011 come from?

[faaslave]

It is a database for our organization.

Field1 is the member type. A = regular member, B = retired member, etc. etc.

Field 2 is the date field for when they started paying dues. Only one value. Sometimes it is blank when their dues haven't started coming out yet.

Every year we have a membership contest to see who recruited the most members. The report will show me who has recruited the most since a certain date. Anybody who had their dues start after 7/1/2011 is in the current figures. Anyone with the field blank is very new and should be in the found set.

The only members that count are in the A, B and C categories of field1.

What I have been doing is perform find, then several constrain or extend lines till I get to the found set I want. It causes some problems though.

I omit all the field1 that have an x

then I omit D

then I omit E

Now I only have A, B, and C members

Then I do a constrain find on field2 values >=07/01/2011

Now comes the problem

I have one more step, I have to add any records that have field2 with no value, but that are only field1 A, B, or C values.

I was hoping this could all be done in a calc with the perform find, (field1 = A, B or C) AND (field2 = (>=07/01/2011) or (=))

I am vey confused

Thanks for the help

[comment]

See if this woks for you:

Find&Constrain.zip

[faaslave]

Comment,

Thank you very much. That is what I was trying to figure out.

Dave