Creating Additional Columns in a Crosstab Query

R

relacy

Hi, I have a Crosstab Query created which pulls the count of column 1,
column 2, column 3, and Total of 1,2, and 3. What I want to do now is create
new columns in the Crosstab Query showing the percents for column 1,2, and 3.

i.e. cnt_1:Int(([1]/[Total Of cnt])*100)
cnt_2:Int(([2]/[Total Of cnt])*100)
cnt_3:Int(([3]/[Total Of cnt])*100)

I have parameters set so this will be a one line listing for an employee
using a date range. I'm stuck.

Any help is greatly appreciated.

Becky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple column values in crosstab query 2
dcount in a crosstab query 3
crosstab query question. 3
Crosstab query and Lookup field problem 3
Totalling Rows and Columns in a Crosstab Query 1
Calaculating a column sum from within the same query 5
insert a crosstab in to temp table query 2
crosstab query 2

Top