In MS Access I am trying to create a Report based on a due date - TechRepublic
Question
October 23, 2010 at 10:53 PM

In MS Access I am trying to create a Report based on a due date

Upon start up of the Access database, I would like the current date to be compared to all the (contract renewal) due dates in a table. If the difference is less than 30 days, I would like to display all the records in a report. The database is essentially to remind me to pay maintenance support for contracts and permits before the lapse.

Would appreciated some tips tod o this. thanks. TK.

This discussion is locked

All Comments