Have a text field in a linked table called Action. Have another date field which sets the Action field based upon what the CAEndDate shows. The below code works if the CAEndDate is < the current date but what i need is to figure out how to set the Action field when month(CAEndDate) and Year(CAEndDate) < LastMonth.
CurrentDb.Execute "UPDATE dbo_t_Detail SET dbo_t_Detail.[Action] = 'No' WHERE (((dbo_t_Detail.CAEndDate)<" & Date & "));"
As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.