In Microsoft Access, the creation of an append action query requires the user to begin with two tables, one being the destination table and the other being the source table. Copy records from the source table to the destination table with help from a computer programming teacher in this free video on Microsoft Access.
Hi, is there any way on how to copy a data in a table to another table by placing it into specific row? because I created 2 tables, one is an ordinary table which has a list of name, nationality, room no. etc. well lets call it (table1). and I have another table which I called it Master database table which has a list of room no., the thing is I want to copy the data from (table1) such as names, nationality etc. into specific row which the correct room no. is located in Master database table.
loti042000 1 week ago