A
Arun vijay
I've been trying to create an access report for a cross tab query.
I've come across various posts providing solution for creating reports
for queries which have date field(months or weeks or years) for a
pivot column. Coming to my specific problem, the crosstab query
resembles as below
TRANSFORM Sum([Amount])
SELECT ProductName
FROM Employees,Sales
WHERE Employees.EmpId=Sales.EmpId
GROUP BY ProductName
PIVOT EmployeeName;
and works just fine while executing the query. Employee Name being the
Column Header, and Product Name being the row header. It might sound a
bit out of place, but while the no of employees may not exceed a max
of 15, the no of products may increase with no restrictions. Currently
assuming there are around 30 products.
Now is it possible to create an access report using this query.
I've come across various posts providing solution for creating reports
for queries which have date field(months or weeks or years) for a
pivot column. Coming to my specific problem, the crosstab query
resembles as below
TRANSFORM Sum([Amount])
SELECT ProductName
FROM Employees,Sales
WHERE Employees.EmpId=Sales.EmpId
GROUP BY ProductName
PIVOT EmployeeName;
and works just fine while executing the query. Employee Name being the
Column Header, and Product Name being the row header. It might sound a
bit out of place, but while the no of employees may not exceed a max
of 15, the no of products may increase with no restrictions. Currently
assuming there are around 30 products.
Now is it possible to create an access report using this query.