i have two tables and i want to add the data of one table at the bottom of the other.
M Mr. Capuchino May 10, 2005 #1 i have two tables and i want to add the data of one table at the bottom of the other.
A Alex White MCDBA MCSE May 10, 2005 #2 you need an insert into query e.g. Insert Into Candidate (First_Name) Select First_Name from Other_Candidate_Table
you need an insert into query e.g. Insert Into Candidate (First_Name) Select First_Name from Other_Candidate_Table
G Guest May 10, 2005 #3 hi, A simple append query will do that. it would select the data from table 1 and append(add) it to table 2. all the fields would have to be the same.
hi, A simple append query will do that. it would select the data from table 1 and append(add) it to table 2. all the fields would have to be the same.
J JohnFol May 10, 2005 #4 ....or if you want to do this purely for a report / for rather than an export you can do a Union Query
....or if you want to do this purely for a report / for rather than an export you can do a Union Query
