Date checking for insurance expiration

[St.Alphonzo]

Hiya... so we are a general contracting firm and we have a table that stores a list of our subcontractors -- [Vendors].... I would like to have a field in this table that shows when their General Liability and Workman's Compensation policies expire (as they are all different and it is a royal pain to flip through all the paperwork) ... since there is no way around manual entry of the start and end dates of each policy, I was wondering if there was a way to create some kind of ticker or pop-up notification upon the expiration date of any given policy... I know this is a basic calendar function that I could employ outside of Access, but I was wondering if there was a script I could write that would execute upon loading the database that would check the [GL Expiration] and [WC Expiration] fields of the [Vendors] table and give some kind of a notification that an expiration is imminent?

[ranman256]

In a query,pull the client, date , and the imminent time, say 30days.
select client, [expDate] from table where dateDiff("d",[expDate],date()) <= 30

find those expired:
select client, [expDate] from table where [expDate]<date()

[St.Alphonzo]

booya! thank you ranman!!