If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Global entry of records
I have a training database where I keep track of training for employees. If
I want to update 10 of those records with the same information, how would I go about doing this instead of updating each individual record? I have tried tagging those records that needed to be updated and used an append query but that didn't work. -- ts |
#2
|
|||
|
|||
Global entry of records
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. -- ts "Tim" wrote: I have a training database where I keep track of training for employees. If I want to update 10 of those records with the same information, how would I go about doing this instead of updating each individual record? I have tried tagging those records that needed to be updated and used an append query but that didn't work. -- ts |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|