troubleshooting Question

Looking at dates and updating records in table

Avatar of Fordraiders
FordraidersFlag for United States of America asked on
Microsoft AccessVBA
13 Comments1 Solution111 ViewsLast Modified:
Access 2010 vba
vba routine needed.

What I have:
Table - called "MyData"
Fields-  "Record_ID" ,  "Status" , "Open_Date",  "Closed_Date"

What I need:

I need a routine that will look at the table("MyData" )  for a ("Status" =  "In_Progress") and ("Closed_Date" = "")
Then take the "Open_Date" value and check to see if it is 10 workings or more old.

If it is
I need to change the "Status" for that record to  "Closed"
ADD A value to ("Closed_Date" = Now() )

Paul Cook-Giles
Senior Application Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros