Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Crosstab Query Percent of total (2000)

    I have a Crosstab Query.
    It has rows with each row having a total.
    I have to sum each column (including the Total column). I know this is done in a report.
    How can I have a Percent of Total Column (in the crosstab query) that takes the sum of the Total column (which I don't have in the query) and divides each of the row totals in the crosstab query ? Can I add a column in the report and do it there since the report has the column total. Any help would be appreciated. Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Crosstab Query Percent of total (2000)

    Say that the text box in the detail section bound to the row total field is named txtTotal, and that the text box in the report footer that calculates the sum of the Total column is named txtSumTotal. Add a new text box in the detail section with Control Source

    <code>=[txtTotal]/[txtSumtotal]</code>

    and set its Format property source to Percent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •