D
dimwit
Hi guyz! Can anyone help me how to pass validation in a pass-through query in
MS Access. I want the between date to com from my ACCESS forms. how can i
change "10/9/2004" from below to [Forms]![frmdate]![txtDate1] and
[Forms]![frmdate]![txtDate2] so that the value it will get is from the form.
THANKS!
SELECT /*+ ORDERED */
d56.tdate
, d50.customer_part_desc AS jobname
, d50.lot_number_count AS lotnum
, d08.layers
, d08.TYPE
, round(((d56.qty_produced + d56.qty_rejected) / d06.parts_per_panel)) AS
numpanels
, d34.dept_code
, d34.dept_name
, d34.unit_ptr
, d34.dept_ptr
, d34.rpt_ptr
FROM CSI_LIVE.data0056 d56
, CSI_LIVE.data0034 d34
, CSI_LIVE.data0006 d06
, CSI_LIVE.data0050 d50
, CSI_LIVE.data0008 d08
WHERE d50.prod_code_ptr = d08.rkey
AND d06.cust_part_ptr = d50.rkey
AND d06.rkey = d56.wo_ptr
AND d56.d_g_w_ptr = d34.rkey
and d34.dept_ptr = 67
and d34.unit_ptr = 4
AND d56.tdate
BETWEEN TO_DATE('10/9/2004', 'mm/dd/yyyy')
AND TO_DATE('10/9/2004', 'mm/dd/yyyy')
MS Access. I want the between date to com from my ACCESS forms. how can i
change "10/9/2004" from below to [Forms]![frmdate]![txtDate1] and
[Forms]![frmdate]![txtDate2] so that the value it will get is from the form.
THANKS!
SELECT /*+ ORDERED */
d56.tdate
, d50.customer_part_desc AS jobname
, d50.lot_number_count AS lotnum
, d08.layers
, d08.TYPE
, round(((d56.qty_produced + d56.qty_rejected) / d06.parts_per_panel)) AS
numpanels
, d34.dept_code
, d34.dept_name
, d34.unit_ptr
, d34.dept_ptr
, d34.rpt_ptr
FROM CSI_LIVE.data0056 d56
, CSI_LIVE.data0034 d34
, CSI_LIVE.data0006 d06
, CSI_LIVE.data0050 d50
, CSI_LIVE.data0008 d08
WHERE d50.prod_code_ptr = d08.rkey
AND d06.cust_part_ptr = d50.rkey
AND d06.rkey = d56.wo_ptr
AND d56.d_g_w_ptr = d34.rkey
and d34.dept_ptr = 67
and d34.unit_ptr = 4
AND d56.tdate
BETWEEN TO_DATE('10/9/2004', 'mm/dd/yyyy')
AND TO_DATE('10/9/2004', 'mm/dd/yyyy')