Clever Geek Handbook

Conditional field value in Access 2007

I created a database to track follow-up customer service activities in a call center environment.
My table has, among others, a Created Date field, a Due Date field, and a Status field (Open, Due or Expired).

I want the value given in the status field to update automatically when the time expires.

Can this be done and how?

+3


source to share


2 answers


This is absolutely possible. Why not? I suggest you do the following:



(1) add another status to the status field called 'closed' (2) define logistically what "Due" means (for example, if the current date is within 5 days after the due date (3) Write a query that updates your status "due" or "expired" depending on the current date

+1


source


UPDATE tblDue SET tblDue.Status = "Due" WHERE (((tblDue.DueDate) = Now ()));



UPDATE tblDue SET tblDue.Status = "Overdue" WHERE (((tblDue.DueDate)> Now ()));

0


source






More articles:


All Articles