Dear MVP's
Thank you for your previous posts about crosstab queries and keeping all rows headings according to another table.
Can i simply take a copy of another crosstab query, and change the sql
I wish to display all names.
This is where i got to..
TRANSFORM First[(Dashboard View Start].Dashboard) AS FirstofDashboard
SELECT [Dashboard View Start].[Full Name]
FROM [Dashboard View Start].[Job Order]
GROUP BY [Dashboard View Start].[Full Name]
PIVOT [Dashboard View Start].[Job Order] In ("7-10 AM", "8-11 AM", "9 AM-12 PM");
Result should be
Time 1, Time 2, Time 3, m...
Name 1 1 3
Name 2 no data exists for intersection, but wish to have all names according to a customer table field.
Name 3 22 34
n...
Any help would be appreciated ( i believe it can e done by left join, or other union joins)
Thank you kindly
Simon