Data input - more than one recd at a time

J

JohnF

Does Access allow you to enter data, in more than one
record at a time ??

Table A: Employee data (Many to Many)
Table B: Military attendance (Many to Many)
Table C: Join Table (One to Many)

What I want to do, is query, these tables, (I had to
create outer join) to give me nul records from table B.
THEN WITH THE RESULTS, I WOULD LIKE TO ENTER IN TABLE B,
ALL IN ONE SHOT GIVING PARTICULARS OF THE EXERCISE. I do
not want to have to enter this data for each record.

Is this possible.

Thanks
John
 
M

Michel Walsh

Hi,


You can append multiple "existing" records (INSERT INTO ... SELECT
.... ), you just have to come with the SELECT statement that produces the
desired new records;

or just one record ( INSERT INTO ... VALUES( ... ) ). The syntax INSERT
INTO VALUES does not allow insertion of more than one record at a time.



Hoping it may help,
Vanderghast, Access MVP
 
J

JohnF

Thank you very much Michel

-----Original Message-----
Hi,


You can append multiple "existing" records (INSERT INTO ... SELECT
.... ), you just have to come with the SELECT statement that produces the
desired new records;

or just one record ( INSERT INTO ... VALUES ( ... ) ). The syntax INSERT
INTO VALUES does not allow insertion of more than one record at a time.



Hoping it may help,
Vanderghast, Access MVP





.
Click to expand...
 
Top