I need to make a query.

[shamna sankar]

I need to make a query.
We have our clients with Name,
State, School, date Purchased and Date Renewal.
I need to have something that will tell us when a
client is going to be due for a renewal. Can anyone please tell me how
to do it?

[Frinavale]

Is the information stored in a database?
Do you know how to connect to a database?
If not then please review the following article that outline how to use a database:
Database tutorial Part 1
Database tutorial Part 2

If you're having problems with creating the appropriate SQL Query, then you should ask the MS SQL Server experts (or if you aren't using MS SQL as your database...choo se the appropriate database forum to ask for help with SQL syntax for your query)