Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Find records that match "Un-Equal To"


Recommended Posts

I use FM 5.5 and in the allowed find symbols there is no search symbol allowing the fine of records in a given field that are un-equal to the search criteria. I have a field titled "Contact Type" and I want to find all records that are un-equal to "Contacted" Any ideas would be appreciated. Are there later versions that have improved search criteria?


Thank you



Link to comment
Share on other sites

See the "Omit" checkbox? When that is checked, you're telling FileMaker to find all records where the entire Request is to be treated as "not this" rather than as "this".


So if you want all records where Field X ≠ "beans", you go into Find Mode, you type in "beans" into Field X, you click the "Omit" checkbox, and hit Enter.


Be aware that if you're mixing Omit with Non-Omit requests, you should put the Omit portions last: that is, if you want all records where Field Y = "vegetables" but you do not want the ones where Field X = "beans", you do it like this:


Enter Find Mode

Set Field [Table::Field Y, "vegetables"]

New Request

Set Field [Table::Field X, "beans"]

Omit Record/Request

Perform Find

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

  • Create New...

Important Information

Terms of Use