Jump to content
Sign in to follow this  
Curlydave

Changing AND to OR

Recommended Posts

I'm trying to create a find where for when either of 2 fields equals a certain value. In Specify Find Requests, i hit "New..." On the left-hand selection I pick my table value, and in the right set my criteria and hit "Add". Then I make another one and add it below. Here's the problem: It says "AND" between the two criteria, and I want it to say "OR", but there's no obvious way to do it. There is also no obvious way to just type out the logic in one line.

How do I make an OR in a find?

Edited by Guest

Share this post


Link to post
Share on other sites

Try something like:

Enter Find Mode []

Set Field [Field1; "yoursearchvalue"]

New Record/Request

Set Field [Field2; "yoursearchvalue"]

Perform Find []

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    dataclip 
×
×
  • Create New...

Important Information

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