In a view : hiding some records according to the value of a field

Posted on 2004-08-03
Medium Priority
Last Modified: 2013-12-18
An easy one... at least, I guess!

Is there any way to hide some records (not a column, but records) according to the value of a field?


I've got the field "TheStatus" in a form, and if the value is "Not Yet Assigned", then I don't want to see those records.  But I want to see all the others.
Question by:barbotte
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2

Expert Comment

ID: 11706821
You just need to set your selection formula for the view to show only the documents you want.

The formula would be this in your example:

TheStatus != "Not Yet Assigned"

Author Comment

ID: 11706917

Just under the line
SELECT Form = "MyForm";

Accepted Solution

HappyFunBall earned 200 total points
ID: 11706927
Ok, yes

Change the formula to this:

SELECT Form = "MyForm" & TheStatus != "Not Yet Assigned"
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 11706973
Thank you for the fast answers!
LVL 19

Expert Comment

ID: 11706995
On the dot HFB. BUt, I would add something. THis would be better when combined with the Form slection formula (Otherwise barbotte will have to post another question) ;)

SELECT FORM = "Form_Name" & TheStatus != "Not Yet Assigned"

LVL 19

Expert Comment

ID: 11707015
Oops! Sorry. I left this open while commenting in the other thread. All well :)

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question