I have a Query with a calculated filed. The field is holding the value of either "1" or "2" based on the iff statment I created. can someone help me with how to filder this query to show me only the records witha value of "1" and then save the filter. I have tried the "filter by selection" but when i get out of the query and then go back in the query is unfiltered again.
If I try and write a condition in the "condition" field then when I run the query it wants to prompt me for input.
I sure this is simplet but I can not figur it out....