Mass Additions

[GirlGeek]

Hello, All.

I have a table that collects training information for our company. Some training is limited to one or two employees and that is easily entered by using a form linked to the table. However, some training is mandatory, company-wide training that all employees must attend. How can I add a record for each employee reflecting this training most efficiently? Is there a way to do a mass update?

Thanks.

 

[Pat Hartman]

You can use an append query to select all employees and add a row for each to the training table.

 

[GirlGeek]

Append Query?

I tried this several times yesterday but could not get it to work. Maybe I'm just not doing it correctly? Any suggestions?

 

[Pat Hartman]

Post your query and we'll help.