Query Not Obeying Search Criteria - Won't Filter Properly

[2tMonte]

I have a database to track documents who are short the proper funding to process. I have two queries, one to track authorizations (contain an "_A" in the document name, and one to track vouchers or local vouchers (contain "_V" for vouchers and "_L" for local vouchers). The idea is to list the documents which or currently short proper funding on a report or query for the budget officer to review. He will then add funds to cover the shortages and check a field called Funded. Once the Funded field is true, the document should drop from the unfunded query and move to the Pending Authorizations query or Pending Documents based on whether the document is an authorization or a voucher. The processing office will then review the list, attempt to process the document and check a field called Document Processed which should remove the document from the query altogether. Right now, the process is working perfectly except I have the records sorted by year (to properly manage fiscal year budgets) and the process only works for 2013 but not 2014. 2014 documents will not remove themselves from the query after the Document Processed field is changed to True. I have tried numerous variations but to no avail.




Thank you all in advance.

[June7]

This SQL is mixing AND and OR operators. Mixed operators can be very tricky. Possibly need the True and False criteria on each criteria row.

[2tMonte]

Big thank to you June7! That is exactly what it was and when I tinkered with the SQL language, it worked. I did learn something about the queries though and that was the easy way to make the same adjustment. While in design view you simply keep adding rows of the criteria. For instance I copied all of the criteria and simply added each year (2013, 2014, etc...) making a row of criteria for each year instead of listing each year in the "or" sections but not filling out the redundant criteria. I guess the criteria was not redundant to Access.

Sorry if I am the only person that this was news to but regardless, this site has increased my knowledge and made me more efficient.