Results 1 to 4 of 4
  1. 02-28-2013, 05:13 PM #1
    Nick Lingenfelter
    Nick Lingenfelter is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    20

    How do I get totals for rows and columns?


    I have the row totals on this report form a crosstab query, but how do I get the column totals?

    Click image for larger version.  Name: Totals.jpg  Views: 8  Size: 33.8 KB  ID: 11351
    Reply With Quote Reply With Quote
  2. 02-28-2013, 05:43 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Typically done in the report footer, with a textbox:

    =Sum(FieldName)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 03-01-2013, 09:46 AM #3
    Nick Lingenfelter
    Nick Lingenfelter is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    20
    That did it, thanks again!
    Reply With Quote Reply With Quote
  4. 03-01-2013, 10:11 AM #4
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Rows to columns
    By zaffar_mughal in forum Access
    Replies: 1
    Last Post: 12-03-2012, 01:18 PM
  2. Totals across Rows in Report
    By SpdRacerX in forum Reports
    Replies: 4
    Last Post: 05-02-2012, 02:08 PM
  3. Rows to columns
    By Jim.H. in forum Access
    Replies: 1
    Last Post: 01-28-2012, 05:29 PM
  4. Rows into Columns
    By chrisdavis in forum Programming
    Replies: 16
    Last Post: 12-22-2011, 01:58 PM
  5. Combining columns into rows
    By steeveepee33 in forum Queries
    Replies: 5
    Last Post: 04-30-2009, 09:18 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums