G
Guest
I have the following:
SELECT
tbl_masterpop_new.[Loan Acct #], tbl_masterpop_new.Status,
tbl_masterpop_new.PopEnterDt
FROM tbl_masterpop_new
UNION ALL SELECT
tbl_masterpop.[Loan Acct #], tbl_masterpop.Status, tbl_masterpop.PopEnterDt
FROM tbl_masterpop;
which only displays the results of the query. I would like to rewrite the
query so that the results are made into a table called tbl_history
thanks in advance,
geebee
SELECT
tbl_masterpop_new.[Loan Acct #], tbl_masterpop_new.Status,
tbl_masterpop_new.PopEnterDt
FROM tbl_masterpop_new
UNION ALL SELECT
tbl_masterpop.[Loan Acct #], tbl_masterpop.Status, tbl_masterpop.PopEnterDt
FROM tbl_masterpop;
which only displays the results of the query. I would like to rewrite the
query so that the results are made into a table called tbl_history
thanks in advance,
geebee