I wrote it like this as criteria in my query for example if I wanted to know if it was expiring within a year with a 30 day advance warning now
>=[Field Name]+335 it seems to work this way but I am not sure it is the right way to do it I will try your code and let you know how I make out thanks for your help Bill
