Hello all,
I'm sure the title doesn't explain much, so let me elaborate on my problem.
We have customer contracts in a table, with fields such as CustomerID, CustomerName, ContractStartDate, etc.
Each customer renews (or doesn't) on the Contract Start Date. I want to write a query to show me which customers haven't yet renewed their contracts for a given period.
So say fifty customers are due to renew on 5/1. Forty have already submitted their papers, and we have their records for the current year. I want a query to show me the other twenty.
I'd really prefer to do it without SQL, as the people managing the data aren't familiar enough with it.
Much appreciated!