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

Top