Global entry of records
Do you have a table of employees? Can you identify (in a query) the employees
you want to add a new training record to? What is the structure of your tables?
Generically, you might have a query like the following.
INSERT INTO EmployeeTrainingSessions (EmployeeID, TrainingID, TrainingDate)
SELECT EmployeeID, 1233, Date()
FROM Employees
WHERE EmployeeName like "S*"
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Tim wrote:
That will not work in my database. I know how to update records using a
query but I want to add a new record for each employee who took a training as
a global procedure so I will not have to go to each employee and add the new
training.
|