Data input - more than one recd at a time

  • Thread starter Thread starter JohnF
  • Start date Start date
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
 
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
 
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...
 
Back
Top