Query about renewal dates

[rlwilliams9]

My database has 105 certification codes i it. I currently have a query that
covers all of them. I have copied and renamed that query for the purpose of
specifying the codes that have no more than a two year renewal period. How
do I accomplish this?

 

[Beetle]

How do you define the renewal period?

Is it just a numeric field representing the number of years?

If so, use criteria of <=2 on that field

Is it a Date/Time field with an expiration date?

If so, use some future date as criteria - <=(DateAdd("yyyy", 2, Date())

_________

Sean Bailey

 

[Jerry Whittle]

Do you have a field that stores renewal periods? What type of data is in it:
numbers or text. By number data type, I mean no ABCs in any record. For
example if it says "two years" in any record, it's a text field.

Next what is the name of the table and fields? What helps a lot is to post
the SQL statement for the query. Open the query in design view. Next go to
View, SQL View and copy and past it here.