I used a Request Table and performed a query to return due dates between 11/26/01 and 12/03/01 for disconnected order, and saved the query. I joined that query to an ORDER Table, and I want to find the due date for the New orders from the ORDER Table that are less than 90 days from the disconnect date in my first query.
Please advise.