A
Alex
I have a combo box on user pick form where users can choose one Operator and
leave the box blank to return all records. How do I revise my below code to
allow users to leave the [frm_Pick_Operation_Emp_Chart]![Operationcmb] field
on my pick form blank? Thank you!
PARAMETERS [forms]![frm_Pick_Operation_Emp_Chart]![BegDatetxt] DateTime,
[forms]![frm_Pick_Operation_Emp_Chart]![EndDatetxt] DateTime,
[forms]![frm_Pick_Operation_Emp_Chart]![Operationcmb] Text ( 255 );
TRANSFORM Sum(qry_Defect_by_Operation_Emp_Chart.[SumOfDef Qnty]) AS
[SumOfSumOfDef Qnty]
SELECT qry_Defect_by_Operation_Emp_Chart.Operation
FROM qry_Defect_by_Operation_Emp_Chart
GROUP BY qry_Defect_by_Operation_Emp_Chart.Operation
PIVOT qry_Defect_by_Operation_Emp_Chart.Oper;
leave the box blank to return all records. How do I revise my below code to
allow users to leave the [frm_Pick_Operation_Emp_Chart]![Operationcmb] field
on my pick form blank? Thank you!
PARAMETERS [forms]![frm_Pick_Operation_Emp_Chart]![BegDatetxt] DateTime,
[forms]![frm_Pick_Operation_Emp_Chart]![EndDatetxt] DateTime,
[forms]![frm_Pick_Operation_Emp_Chart]![Operationcmb] Text ( 255 );
TRANSFORM Sum(qry_Defect_by_Operation_Emp_Chart.[SumOfDef Qnty]) AS
[SumOfSumOfDef Qnty]
SELECT qry_Defect_by_Operation_Emp_Chart.Operation
FROM qry_Defect_by_Operation_Emp_Chart
GROUP BY qry_Defect_by_Operation_Emp_Chart.Operation
PIVOT qry_Defect_by_Operation_Emp_Chart.Oper;