I have a table and I created a query that I wanted it to pull a certain type from the field for the fiscal year that was asked. In my criteria I had "Fixed", then I decided I needed to see "Special" as well so I added it to the or field in the query and then it returned not just fiscal 2023 which is what was asked for but all the way back to fiscal year 2017. I included before and after screen shots for this.
Before adding Special:
After adding Special
Any ideas on what I did wrong?
Before adding Special:
After adding Special
Any ideas on what I did wrong?