SELECT
O858IA_VWRDCAM.NVP_BID_NR,
O858IA_VWRDCAM.SRC_CNY_CD,
O858IA_VWRDCAM.PRC_JOB_LST_RUN_DT,
O858IA_VWRDCAM.COS_CCL_MTH_TYP_CD,
O858IA_VWRDCAM.PKG_CHA_TYP_CD,
O858IA_VWRDCAM.SVC_TYP_CD,
O858IA_VWRDCAM.MVM_DRC_CD,
O858IA_VWRDCAM.ORG_CNY_IAT_CD,
O858IA_VWRDCAM.DTN_CNY_IAT_CD,
([SMT_BIL_WGT_QY]*O858IA_VWRDCAM!DEL_LOC_PKG_QY) AS Billed_Wgt,
Sum(([SMT_BIL_WGT_QY]*O858IA_VWRDCAM!DEL_LOC_PKG_QY)) AS Sum_Billed_Wgt,
Sum(([LNE_PKG_AVG_CU_QY]*O858IA_VWRDCAM!DEL_LOC_PKG_QY)) AS Cube,
Sum(O858IA_VWRDCAM.DEL_LOC_PKG_QY) AS SumOfDEL_LOC_PKG_QY,
Sum(O858IA_VWRDCAM.DEL_LOC_SMT_QY) AS SumOfDEL_LOC_SMT_QY,
Sum(O858IA_VWRDCAM.DEL_LOC_SMT_GRR_A) AS SumOfDEL_LOC_SMT_GRR_A,
Sum(O858IA_VWRDCAM.DEL_LOC_SMT_NRV_A) AS SumOfDEL_LOC_SMT_NRV_A,
Sum((([pdc_pus_fxc_cpp_a] + [pdc_pus_tvl_cpp_a] + [pdc_pus_vhc_cpp_a] + [pdc_pus_pal_fxc_a] + [pdc_pus_pal_vhc_a] + [pdc_pus_cki_cpp_a] + [pdc_pus_oth_cpp_a] + [pdc_pus_smt_avg_a] + [pdc_pus_smt_vhc_a] + [pdc_pus_grr_a] + [pdc_pus_xtn_cpp_a]) * [del_loc_pkg_qy])) AS PU,
Sum((([pdc_ls_rgr_cpp_a] + [pdc_ls_irr_cpp_a]) * [del_loc_pkg_qy]) ) AS LS,
Sum((([pdc_snk_cs_rgr_a]+[pdc_snk_cs_irr_a]+[pdc_snk_cs_fxc_a]+[pdc_cs_smt_fxc_a]+[pdc_cs_smt_vhc_a]+[pdc_ls_tns_vhc_a])*[del_loc_pkg_qy])) AS CS,
Sum((([pdc_org_snk_gnf_a]+[pdc_dtn_snk_gnf_a]+[pdc_snk_ldf_cpp_a]+[pdc_snk_tfc_gnf_a]+[pdc_snk_tlr_cpp_a]+[pdc_snk_sxb_ldf_a])*[del_loc_pkg_qy])) AS FDR,
Sum((([pdc_snk_rmp_fxc_a]+[pdc_snk_rmp_vrc_a])*[del_loc_pkg_qy])) AS RMP,
Sum((([pdc_snk_jet_arf_a]+[pdc_snk_jet_fxc_a]+[pdc_snk_jet_vrc_a]+[pdc_org_snk_arf_a]+[pdc_dtn_snk_arf_a]+[pdc_snk_jet_wgt_a]+[pdc_org_snk_asf_a]+[pdc_dtn_snk_asf_a])*[del_loc_pkg_qy])) AS AFD,
Sum((([pdc_prl_rgr_cpp_a]+[pdc_prl_irr_cpp_a]+[sml_pkg_pdv_cos_a])*[del_loc_pkg_qy])) AS PRL,
Sum((([pdc_ds_fxc_cpp_a]+[pdc_ds_tvl_cpp_a]+[pdc_ds_vhc_cpp_a]+[pdc_ds_pal_fxc_a]+[pdc_ds_pal_vhc_a]+[pdc_ds_cki_cpp_a]+[pdc_ds_oth_cpp_a]+[pdc_ds_sag_cpp_a]+[pdc_ds_smt_avg_a]+[pdc_ds_smt_vhc_a]+[pdc_ds_grr_a]+[pdc_ds_xtn_cpp_a]+[sml_del_vhc_a])*[del_loc_pkg_qy])) AS DEL,
Sum((([pdc_org_bkr_smt_a]+[pdc_dtn_bkr_smt_a]))) AS BKR,
Sum((([pdc_frq_nop_cpp_a]+[pdc_vnr_nop_cpp_a]+[pdc_org_nop_grr_a]+[pdc_org_nop_a]+[pdc_org_nop_smt_a]+[pdc_org_igs_a]+[pdc_org_igs_smt_a]+[pdc_org_igs_grr_a]+[pdc_org_ovh_grr_a]+[pdc_dtn_nop_grr_a]+[pdc_dtn_nop_a]+[pdc_dtn_nop_smt_a]+[pdc_dtn_igs_a]+[pdc_dtn_igs_smt_a]+[pdc_dtn_igs_grr_a]+[pdc_dtn_ovh_grr_a]+[pdc_oth_nop_a]+[pdc_oth_nop_smt_a]+[pdc_oth_nop_grr_a])*[del_loc_pkg_qy])) AS NOP,
O858IA_VWRDCAM.MIN_NET_RVN_APL_IR INTO RAW1
FROM O858IA_VWRDCAM
GROUP BY
O858IA_VWRDCAM.NVP_BID_NR,
O858IA_VWRDCAM.SRC_CNY_CD,
O858IA_VWRDCAM.PRC_JOB_LST_RUN_DT,
O858IA_VWRDCAM.COS_CCL_MTH_TYP_CD,
O858IA_VWRDCAM.PKG_CHA_TYP_CD,
O858IA_VWRDCAM.SVC_TYP_CD,
O858IA_VWRDCAM.MVM_DRC_CD,
O858IA_VWRDCAM.ORG_CNY_IAT_CD,
O858IA_VWRDCAM.DTN_CNY_IAT_CD,
([SMT_BIL_WGT_QY]*O858IA_VWRDCAM!DEL_LOC_PKG_QY),
O858IA_VWRDCAM.MIN_NET_RVN_APL_IR
HAVING ( ( (O858IA_VWRDCAM.NVP_BID_NR) = Trim([forms]![James Form]![Bid number]) ) AND
( (O858IA_VWRDCAM.PRC_JOB_LST_RUN_DT) Between [forms]![James Form]![ICLOR Start] And [forms]![James Form]![ICLOR End] ) AND
( (O858IA_VWRDCAM.COS_CCL_MTH_TYP_CD)=IIf([Forms]![James Form]![Future cost]=True,"00") ) AND
( (Sum(O858IA_VWRDCAM.DEL_LOC_SMT_GRR_A))>0 )
);