Search results

This is how my current database is setup. I have a renewal field, 30Days, 60Days, 90Days calculated field ([renewal] -30, etc..), which are displaying the correct dates. What I am trying to achieve is to see what contracts expire in 30, 60, 90 days out. Here is an example of one of my...

I have a problem with one of my queries that I created and due to my lack of Access experience I'm not sure how to fix it. In my contract database, I have a renewal field and one calculated field called 90 days. In my 90days query, I used Month(Now()) in the criteria field and everything was...