How to make report autoupdate with crosstab query

[Ben Saeed]

Hello,

I made a report with following crosstab query.

TRANSFORM Workersdetail.workername AS CountOfedate
SELECT Workersdetail.[attendance], Count(Workersdetail.[edate]) AS [Total Of edate]
FROM Workersdetail
GROUP BY Workersdetail.[Workername], Workersdetail.[attendance], Workersdetail.[workerhourenter]
PIVOT site+Cstr([workerhourenter])

I wanted to know that, is there any option through which my report gets autoupdate or refresh incase of addition in SITE field (as metioned with PIVOT)?

Best regards,

Ben

 

[Pat Hartman]

No. There is no automatic way to change the columns. This article might give you some ideas on how to solve the problem:
http://www.fmsinc.com/MicrosoftAccess/query/crosstab-report/index.html