barbotte
asked on
In a view : hiding some records according to the value of a field
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?
Example:
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.
Is there any way to hide some records (not a column, but records) according to the value of a field?
Example:
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.
ASKER
???
Just under the line
SELECT Form = "MyForm";
Just under the line
SELECT Form = "MyForm";
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the fast answers!
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"
SELECT FORM = "Form_Name" & TheStatus != "Not Yet Assigned"
Oops! Sorry. I left this open while commenting in the other thread. All well :)
The formula would be this in your example:
TheStatus != "Not Yet Assigned"