calculation in Crosstab Query

[tngirl]

Is it possible to create a calculation for the values in a cross tab query? I need to display the passing quality score percentage for each employee for each month. i will need to use the total passing records for each employee for each month then divided that by the total QA records for each month. I'm not sure if this is possible with a crosstab query.

I appreciate your help, thank you

[June7]

Not easy with any query.

Easy with a report based on raw data table and using Grouping & Sorting features and summary calcs in footers.

Building a report based on CROSSTAB to run perpetually is not simple because of the dynamic nature of the column headings, especially for date values.

[tngirl]

I can do the calculation in the report, but in a standard report, how would I make the column headings prefil the month/yr based on the start date enter? I would like this to display 12 months of data based on the start date entered. Thank you for your help

[June7]

Your other thread https://www.accessforums.net/reports...ort-42244.html

[tngirl]

can you please elaborate on what a temp table is, thank you.

[June7]

A temp table is a table that temporarily holds records for a procedure. The records are deleted when the procedure completes.