Results 1 to 4 of 4
  1. #1
    abc is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2011
    Posts
    3

    Post Subtotal

    I have a table that contains account transactions (date, account, value). What is the easiest way to create one report that displays a total by each account (subtotal)?




    thank you

  2. #2
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,171
    Hi,

    the easiest way is using the Grouping possibility in the report itself. You can do this very easily using the report wizzard.

    success
    NG

  3. #3
    abc is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2011
    Posts
    3
    Thank you for your suggestion, but is there a way to only show the total of each account, rather than showing each data entry?

  4. #4
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,171
    Yes, that too can be done using the grouping options

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 07-15-2010, 12:32 PM
  2. Replies: 25
    Last Post: 03-31-2010, 11:10 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
  •  
Other Forums: Microsoft Office Forums