Parameter in Row does not appear if no value

  • Thread starter Thread starter Bart
  • Start date Start date
B

Bart

I have a cross tab query below:

Total Open In-Progress
Support A 2 2
Support B 1 1

I have 3 parameters namely "Support A", "Support B" and "Support C".
However "Support C" does not appear because there is no value for "Open" and
"In-Progress" field. But I want to show all my parameters even there is no
value for "Support C"
 
You need to post your SQL, but the solution probably lies in changing
an INNER JOIN to a LEFT JOIN
 
Here is the SQL:
TRANSFORM Val(Nz(Count(Computation.[Ref No]),0)) AS [CountOfRef No]
SELECT Computation.[Owners Group], Count(Computation.[Ref No]) AS [Total Of
Ref No]
FROM Computation
GROUP BY Computation.[Owners Group]
PIVOT Computation.NoOfMonth In ("<1 Month",">1 Month",">2 Months",">3
Months",">4 Months",">5 Months");
 
Back
Top