After going through lesson Lesson 17.3 and 26 years of working in Accounts Payable and Procurement I came back here to modify this query. Nothing wrong with the queries in either lesson. In order to accommodate my changes I made to the queries in 17.3 I needed to change this query also.
Archive quotes over x # of days and unpaid invoices over x # of days IsQuoatation True And [OrderDate]<Date()-90 And [IsPaid]=False or False And [OrderDate]<Date()-365 And [IsPaid]=False
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 17.
