Jump to content
Sign in to follow this  
Thomas An

Find "either / or" ?

Recommended Posts

I would like to perform a find on field 'A' so that it returns the records that contain either the value (say) 131 or the value 101 (but nothing else).

CORRECTION: ".. returns the records that contain the value (say) 131 *and* the value 101 (but nothing else)."

The problem is that this find will operate on top of a previous find. In other words, we cannot simply do a search to omit the first number, then constrain to omit the second number and then invert ... because this will also bring in values from the initially constrained set.

Edited by Guest

Share this post


Link to post
Share on other sites

Enter Find mode and create separate requests for each criteria, then use the Constrain Found Set command to constrain from the previous found set.

Share this post


Link to post
Share on other sites

Enter Find mode and create separate requests for each criteria, then use the Constrain Found Set command to constrain from the previous found set.

oops ??? I made an error earlier.

What I meant to say was that we want the final found set to contain records whose field 'A' contains the number (say) either 131 or 101. So both 131 and 101 will be in the found set.

If we do a sequential constrain (first for 131 and then for 101), the first found set will have eliminated all 101 entries and there will be nothing left to constrain to in the second step.

Share this post


Link to post
Share on other sites

Hi Thomas,

I thought I understood what you were going for, but now I'm confused. Now it sounds like you just need an [color:blue]OR search.

Enter Find mode

Field A = 101

New Record Request

Field A = 131

Perform Find

Lee

Share this post


Link to post
Share on other sites

Hi Thomas,

I thought I understood what you were going for, but now I'm confused. Now it sounds like you just need an [color:blue]OR search.

Enter Find mode

Field A = 101

New Record Request

Field A = 131

Perform Find

Lee

Lee,

That looks like it will solve my problem.

You have an interesting use of "New record request" which I did not know before.

But I want to make sure. It does not create a new physical record ? Is it only a temporary thing while inside the find mode ?

Share this post


Link to post
Share on other sites

In Find Mode, the New Record Request give you another Find Record for your request.

It is [color:red]Not creating a new record.

Lee

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.