Thank you. I have created a query that pulls the contract end dates in ascending order. Ideally I would like it to do that when the contract end date is 30 days away so we can prepare to start looking out for it...I have also set a macro to run the query but I can't work out how to phrase the...