Creating Additional Columns in a Crosstab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top