A
Alex
I have a table, biweektbl, that lists all the possible Bi-Weekly shifts. Is
there a way to revise the following crosstab query to include all Bi-Weekly
shifts listed in that table even if there are no values in the query results.
I'm using the crosstab query for a chart and need to show columns for null
series as well. Thanks.
PARAMETERS [forms]![frm_Pick_Operation_Shift_Chart]![StartDate] DateTime,
[forms]![frm_Pick_Operation_Shift_Chart]![EndDate] DateTime,
[forms]![frm_Pick_Operation_Shift_Chart]![Sectcmb] Text ( 255 ),
[forms]![frm_Pick_Operation_Shift_Chart]![Operationcmb] Text ( 255 ),
[forms]![frm_Pick_Operation_Shift_Chart]![Shiftcmb] IEEEDouble;
TRANSFORM Sum(qry_Defects_by_Oper_Shift_Chart.[SumOfDef Qnty]) AS
[SumOfSumOfDef Qnty]
SELECT " Bi-Weekly " & [WkCode] & " - Shift " & [Shft] AS Expr1
FROM qry_Defects_by_Oper_Shift_Chart
WHERE (((qry_Defects_by_Oper_Shift_Chart.Shft) Like
[forms]![frm_Pick_Operation_Shift_Chart]![Shiftcmb])) OR
((([forms]![frm_Pick_Operation_Shift_Chart]![Shiftcmb]) Is Null))
GROUP BY " Bi-Weekly " & [WkCode] & " - Shift " & [Shft]
PIVOT qry_Defects_by_Oper_Shift_Chart.Defect;
there a way to revise the following crosstab query to include all Bi-Weekly
shifts listed in that table even if there are no values in the query results.
I'm using the crosstab query for a chart and need to show columns for null
series as well. Thanks.
PARAMETERS [forms]![frm_Pick_Operation_Shift_Chart]![StartDate] DateTime,
[forms]![frm_Pick_Operation_Shift_Chart]![EndDate] DateTime,
[forms]![frm_Pick_Operation_Shift_Chart]![Sectcmb] Text ( 255 ),
[forms]![frm_Pick_Operation_Shift_Chart]![Operationcmb] Text ( 255 ),
[forms]![frm_Pick_Operation_Shift_Chart]![Shiftcmb] IEEEDouble;
TRANSFORM Sum(qry_Defects_by_Oper_Shift_Chart.[SumOfDef Qnty]) AS
[SumOfSumOfDef Qnty]
SELECT " Bi-Weekly " & [WkCode] & " - Shift " & [Shft] AS Expr1
FROM qry_Defects_by_Oper_Shift_Chart
WHERE (((qry_Defects_by_Oper_Shift_Chart.Shft) Like
[forms]![frm_Pick_Operation_Shift_Chart]![Shiftcmb])) OR
((([forms]![frm_Pick_Operation_Shift_Chart]![Shiftcmb]) Is Null))
GROUP BY " Bi-Weekly " & [WkCode] & " - Shift " & [Shft]
PIVOT qry_Defects_by_Oper_Shift_Chart.Defect;