Inserting Records?

J

jedooley

Registered User.
Local time
Yesterday, 17:09
Joined
Sep 22, 2004
Messages
20
Can I insert records into a query that joins 3 tables? I need to do an insert statement into 3 different tables at the same time. Is it possible?
 
Yes, No, Maybe

Yes, As long as your query is updateable.

Check the Access Help File, and search

"When can I update data from a query?"

:cool:
 
You must log in or register to reply here.

Similar threads

AOB
Solved Insert records where ID combination not already present (JOIN expression not supported)
Replies
2
Views
332
arnelgp
arnelgp
J
ms access query by insert a random record which not exist in other table
Replies
8
Views
686
Pat Hartman
P
AOB
Solved Parameterised query requires me to re-cast parameter in order to run (?)
Replies
6
Views
395
AOB
AOB
K
Solved Insert Into - Select
Replies
18
Views
893
arnelgp
arnelgp
mike60smart
Inserting Dates
Replies
10
Views
640
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom