Does a crosstab query auto update?

[jonathanchye]

Just want to be sure about this so I guess its always better to ask

I have a report generated based on a crosstab query which is in turn based on a query.

When I run the report will Access automatically update the report which originates some the query or do I have to run the query again and recreate the crosstab?

 

[DJkarl]

Queries report on the data that is available, if your crosstab query is built on a select query and the data source of the select query is updated, then the crosstab will be updated everytime you run/open it.

 

[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