COPY MANY RECORDS

[Guest]

I HAVE TABLE INCLUDE EMPLOYEES fileds name (EmpID , NAME , DEPARTMENT )
and i have 5 records for employees in sals department
SO I WANT TO INSERT the same 5 records in the sals department to another new
department
( duplicate many frecords with new department)
thank you

 

[David F Cox]

It is called an APPEND query. Append is in capital letters because it is an
Access keyword. It is considered bad practise to use all capital letters for
things that are not Access keywords. (known as "shouting" in newsgroups.)

Department is not ankeyword, so should be written Department, or better
still [Department], so it can be more easily recognised as a field name. You
should avoid using keywords as field names it can cause errors, human and
machine. NAME is an Access keyword. See Keywords under help.

Write a SELECT query to select the records you want, and change it to an
APPEND query changing any fields that need to be changed.