Could you please help, I want create query that will put date from one table to another?
Could you please help, I want create query that will put date from one table to another?
Maybe something like:
INSERT INTO table1(field1, field2, field3) SELECT field1, field2, field3 FROM table2;
Without more info about what you really need to accomplish and your data structure, can't be more specific.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Can I do it with Query?
What I posted is the statement for an SQL action query.
Use query builder. Switch to SQL View to see and edit the statement.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.