Jump to content

Omitting Records When Field Is Empty


Recommended Posts

  • Newbies

I am attempting the simple task of omitting those records from a search result when a specific field is empty. The obvious solution, Constrain Found Set > Omit Records > Criteria = "" (equal sign omitted) for some reason doesn't do the trick as I'm still getting records that have empty values in that field.

Thanks.

OmitIssue.jpg

Link to post
Share on other sites

Use:

== 

as the criteria, instead of:

""

 

---
Unrelated to your question, but I couldn't help noticing that you have numbered fields. This is usually a symptom of poor structure.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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