Aiysha

<div>
<div class="content wysiwyg-content">
How can I make access query to delete all data from a table and then insert new data. I want to do this in the one query. <br />
<br />
DELETE FROM FORECAST<br />
INSERT INTO FORECAST ( PROPNUM, RE_ENG_TAG, WELL_NAME, OUTDATE, [Gross Oil], [Gross Gas], [Gross Water] )<br />
SELECT ariesadmin_AC_MONTHLY.PROP<wbr />NUM, ariesadmin_AC_PROPERTY.RE_<wbr />ENG_TAG, ariesadmin_AC_PROPERTY.WEL<wbr />L_NAME, ariesadmin_AC_MONTHLY.OUTD<wbr />ATE, ariesadmin_AC_MONTHLY.S370<wbr />, ariesadmin_AC_MONTHLY.S371<wbr />, ariesadmin_AC_MONTHLY.S376<wbr /><br />
FROM ariesadmin_AC_MONTHLY RIGHT JOIN ariesadmin_AC_PROPERTY ON ariesadmin_AC_MONTHLY.PROP<wbr />NUM = ariesadmin_AC_PROPERTY.PRO<wbr />PNUM;<br />
<br />
Thank you.
</div>
</div>


How can I make access query to delete all data from a table and then insert new data. I want to do this in the one query. 

DELETE FROM FORECAST
INSERT INTO FORECAST ( PROPNUM, RE_ENG_TAG, WELL_NAME, OUTDATE, [Gross Oil], [Gross Gas], [Gross Water] )
SELECT ariesadmin_AC_MONTHLY.PROPNUM, ariesadmin_AC_PROPERTY.RE_ENG_TAG, ariesadmin_AC_PROPERTY.WELL_NAME, ariesadmin_AC_MONTHLY.OUTDATE, ariesadmin_AC_MONTHLY.S370, ariesadmin_AC_MONTHLY.S371, ariesadmin_AC_MONTHLY.S376
FROM ariesadmin_AC_MONTHLY RIGHT JOIN ariesadmin_AC_PROPERTY ON ariesadmin_AC_MONTHLY.PROPNUM = ariesadmin_AC_PROPERTY.PROPNUM;

Thank you.

Delete table and insert new values.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.