Hi Forum,
Is it possible to have calculated Controls on a Report that uses a crosstab Query as it's data source??

I have a crosstab query that has the raw data needed for our Month End Statistics Report.

I used to export a report of this to excel and work from there but now wondering if using calculated controls will achieve the result easier.

My attempts so far have failed:eek:

Assuming we still export to Excel. How best to do this?? Export the Report or can the Crosstab Query be exported from datasheet view??

Appreciate some direction / advice.:)

:o My attempt didn't fail. Just had to add Nz([Controlsource],0) in the calculations.
Most rows of data failed and I just noticed a couple that worked and now after adding the Nz() they all work:)

Still appreciate some advice on exporting to Excel.
best to export the query result or a report??

Try both and see which one works better for you. With the report option the report would have to load.