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.