Code:
INSERT INTO DATA_CUST_QUOTE_LINE_TBL_1 ( PREV_QUOTED
,NEW_QUOTED
,PREV_EXTENDED_PRICE
,NEW_EXTENDED_PRICE
,ORDER_DATE
,CUSTOMER_ID
,QUOTE_DATE
,WON_LOSS_DATE
,QUOTE_ID
,LINE_NO
,PART_ID
,CUSTOMER_PART_ID
,DRAWING_ID
,DRAWING_REV_NO
,ORDER_QTY
,UNIT_PRICE
,EXTENDED_PRICE
,CUSTOMER_NAME
,PRODUCT_CODE
,COMMODITY_CODE
,CUST_GROUP
,SALESREP_ID
,TERRITORY
,SIC_CODE
,STATUS
,CURRENCY_ID
,TYPE
,QUOTE_LINK_TYPE
,PART_CREATE_DATE
,MASTER_QUOTE_ID
,MASTER_QUOTE_LINE
,MASTER_USER7 )
SELECT IIf([vCUST_QUOTE_LINE]![QUOTE_DATE]<[Forms]![New Part Performance]![FromDate] >
,1
,0) AS PREV_QUOTED
,IIf([vCUST_QUOTE_LINE]![QUOTE_DATE] Between [Forms]![New Part Performance]![FromDate] And [Forms]![New Part Performance]![ToDate]
,1
,0) AS NEW_QUOTED
,IIf([vCUST_QUOTE_LINE]![QUOTE_DATE]<[Forms]![New Part Performance]![FromDate] >
,[vCUST_QUOTE_LINE]![EXTENDED_PRICE]
,0) AS PREV_EXTENDED
,IIf([vCUST_QUOTE_LINE]![QUOTE_DATE] Between [Forms]![New Part Performance]![FromDate] And [Forms]![New Part Performance]![ToDate]
,[vCUST_QUOTE_LINE]![EXTENDED_PRICE]
,0) AS NEW_EXTENDED
,vCUST_QUOTE_LINE.ORDER_DATE
,vCUST_QUOTE_LINE.CUSTOMER_ID
,vCUST_QUOTE_LINE.QUOTE_DATE
,vCUST_QUOTE_LINE.WON_LOSS_DATE
,vCUST_QUOTE_LINE.QUOTE_ID
,vCUST_QUOTE_LINE.LINE_NO
,IIf(vPARTS!PART_ID Is Null
,vCUST_QUOTE_LINE!PART_ID
,vPARTS!PART_ID) AS PART_ID1
,IIf(vPARTS!CUSTOMER_PART_ID Is Null
,vCUST_QUOTE_LINE!CUSTOMER_PART_ID
,vPARTS!CUST OMER_PART_ID) AS CUSTOMER_PART_ID1
,IIf(vPARTS!DRAWING_ID Is Null
,vCUST_QUOTE_LINE!DRAWING_ID
,vPARTS!DRAWING_ID ) AS DRAWING_ID1
,IIf(vPARTS!DRAWING_REV_NO Is Null
,vCUST_QUOTE_LINE!DRAWING_REV_NO
,vPARTS!DRAWIN G_REV_NO) AS DRAWING_REV_NO1
,vCUST_QUOTE_LINE.ORDER_QTY
,vCUST_QUOTE_LINE.UNIT_PRICE
,vCUST_QUOTE_LINE.EXTENDED_PRICE
,IIf(vPARTS!CUSTOMER_NAME Is Null
,vCUST_QUOTE_LINE!CUSTOMER_NAME
,vPARTS!CUSTOME R_NAME) AS CUSTOMER_NAME1
,IIf(vPARTS!PRODUCT_CODE Is Null
,vCUST_QUOTE_LINE!PRODUCT_CODE
,vPARTS!PRODUCT_ CODE) AS PRODUCT_CODE1
,IIf(vPARTS!COMMODITY_CODE Is Null
,vCUST_QUOTE_LINE!COMMODITY_CODE
,vPARTS!COMMOD ITY_CODE) AS COMMODITY_CODE1
,IIf(vPARTS!CUSTOMER_GROUP Is Null
,vCUST_QUOTE_LINE!CUST_GROUP
,vPARTS!CUSTOMER_G ROUP) AS CUSTOMER_GROUP1
,vCUST_QUOTE_LINE.SALESREP_ID
,vCUST_QUOTE_LINE.TERRITORY
,IIf(vPARTS!CUSTOMER_SIC_CODE Is Null
,vCUST_QUOTE_LINE!SIC_CODE
,vPARTS!CUSTOMER_SIC _CODE) AS CUSTOMER_SIC_CODE1
,vCUST_QUOTE_LINE.STATUS
,vCUST_QUOTE_LINE.CURRENCY_ID
,'Q' AS TYPE
,IIf(vPARTS!PART_ID Is Null
,Null
,'M') AS QUOTE_LINK_TYPE
,vPARTS.CREATE_DATE
,vPARTS.QUOTE_ID
,vPARTS.QUOTE_LINE
,vPARTS.USER_7
FROM vCUST_QUOTE_LINE
LEFT JOIN vPARTS ON (vCUST_QUOTE_LINE.CUSTOMER_PART_ID = vPARTS.CUSTOMER_PART_ID) AND (vCUST_QUOTE_LINE.LINE_NO = vPARTS.QUOTE_LINE) AND (vCUST_QUOTE_LINE.QUOTE_ID = vPARTS.QUOTE_ID)
WHERE (((vCUST_QUOTE_LINE.CUSTOMER_ID) Between [Forms]![New Part Performance]![CFrom] And [Forms]![New Part Performance]![CTo]) AND ((vCUST_QUOTE_LINE.QUOTE_DATE) Between [Forms]![New Part Performance]![txtFromDate] And [Forms]![New Part Performance]![txtToDate])) OR (((vCUST_QUOTE_LINE.ORDER_DATE) Between [Forms]![New Part Performance]![txtFromDate] And [Forms]![New Part Performance]![txtToDate]) AND ((vCUST_QUOTE_LINE.CUSTOMER_ID) Between [Forms]![New Part Performance]![CFrom] And [Forms]![New Part Performance]![CCto]))