We help IT Professionals succeed at work.
Get Started

Access 2007 Question on automation

jjc9809 asked
Last Modified: 2012-05-12
Hi everyone,

I am trying to determine the number of months an employee has worked to pay an employee a Longevity check for the year.  The check will be based on the number of months worked.  

I have an Access 2007 database that is updated monthly and all of my fields for the an employee are updated to a table called Complete Employment New.  I do not want to mess with this table by adding a field to it, because I could mess up the automation that is happeing behind the scenes with this table.  So I need to take the Complete Employment New Table and place it in a select query and then create a Make Table Query which will give me a new Table called LongevityNewTableOctober.  Once the new table is created with the Make Table Query, I need to automatically add a new field to the table behind the scenes called DATETO and have DATETO as a Text Data Type.

I then will have an Update Query that will need to run and place a December date in the DATETO field each year for each employee in the LongevityNewTableOctober.  The December Date will change each year.  This year the Update Query had the DATETO field from the LongevityNewTableOctober and when it ran it updated the DATETO field to "12/1/11".  I have placed in the Update Query on the Section "UPDATETO:  the date, "12/1/11" manually.  I need to somehow increment the year by one each year automatically without having to go in and change the "updateTo in the query section each time.  Can this be done automatically somehow?  Also, can I add a new field to the table that is made with the Make Table each time automatically without having to go in the created Make Table and manually place a DATETYO Field and make the Data type Text?

Watch Question
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE