debauch
08-24-2007, 12:44 PM
Hello,
I am an Access newb. but it more useful than Excel to maintain data. My question is, can you have a record move to table 3, if it finds a match in table 1 and table 2?
In more detail, I will have an active users table, a terminated user table (3), and a table that gets a new feed of terminated users(2). I want the 'feed' to pull the active users(1) (by employee ID) and put them into the terminated table??
Would this be done running a macro, or is there a basic query that would do the trick?
I am an Access newb. but it more useful than Excel to maintain data. My question is, can you have a record move to table 3, if it finds a match in table 1 and table 2?
In more detail, I will have an active users table, a terminated user table (3), and a table that gets a new feed of terminated users(2). I want the 'feed' to pull the active users(1) (by employee ID) and put them into the terminated table??
Would this be done running a macro, or is there a basic query that would do the trick?