Filtering a Query

[jbarrum]

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....

[jbarrum]

I am trying to write a report that will show me orders that were placed in the current year only. I have mananged to create the calculated column that will display the value of "1" if it is the current year and a "2" if it is the previous year. The Query will automatcally update the value each year when the date "year" changes. I just need to be able to limit the query to records in the current year only. can this be done?

I have tried everything.