G
Guest
I am a novice Access user and need all the assistance I can get.
I have a database I created in Access 2003. The database is for employee
information and the time spent on a contract account. Each person could have
one or more entries dependent upon the number of times they left and returned
to the account.
My database contains the last name, first name, middle initial, start date,
current term and term date as well as two types of human resources related
data.
What I would like to do is run a macro that will remove duplicate data if
specific criteria are met such as the current date and term date are
populated. Additionally, I would like to remove data for employees who left
the account prior to 2007.
I'm not sure if this would be a Macro or using VBA.
I have a database I created in Access 2003. The database is for employee
information and the time spent on a contract account. Each person could have
one or more entries dependent upon the number of times they left and returned
to the account.
My database contains the last name, first name, middle initial, start date,
current term and term date as well as two types of human resources related
data.
What I would like to do is run a macro that will remove duplicate data if
specific criteria are met such as the current date and term date are
populated. Additionally, I would like to remove data for employees who left
the account prior to 2007.
I'm not sure if this would be a Macro or using VBA.