I need to do a find using an "And" "Or" condition. I have five fields. This criteria needs to be met for the record to be accepted into the Find results:

Field1 > 0 "AND"

Field2 > 0 "OR"

Field3 > 0 "OR"

Field4 > 0 "OR"

Field5 > 0

How do I accomplish this please.

Regards, Brooke

make 4 find requests. Each of them will have >0 in field 1. And they will have >0 in Fields 2-5 respectively for each request.

for any find, having criteria in two different fields is an AND search, where each different request is OR.

Thanks for your help, but apparently I am missing something. I had already tried that assuming that once a sub set of data was returned the next find would use that set of data. Upon further reading I find out that each find uses the complete set of data. Is this a version issue? I'm using version 5.

Thanks, Brooke

Hi Brooke (Great Name, I have a granddaughter's with that name)

No, the find as described by Reed is correct for all of the versions I have, including v5. It may be you are confused by something like the New Record Requests. If you enter all of the > 0 in ONE find request, it is called an "AND" find, meaning all of the fields in this request would have to met the > 0. To find records that all have a >0 in Field1 and >0 in one of the other fields, you need to enter each request on its own request. To do this,

Enter Find Mode, enter these two entries:

Field1 > 0

Field2 > 0

New Record Request (Menu-Records-New Records), enter these two entries:

Field1 > 0

Field3 >0

New Record Request (Menu-Records-New Records), enter these two entries:

Field1 > 0

Field4 >0

New Record Request (Menu-Records-New Records), enter these two entries:

Field1 > 0

Field5 >0

Hit the Find Button.

HTH

Lee

Ahhh, now I see. Thanks for your help...

Regards, Brooke