Results 1 to 5 of 5
  1. #1
    babylikesburgh is offline Novice
    Windows Vista Access 2003
    Join Date
    Feb 2010
    Posts
    3

    Question Totals in a query-based report

    Hi everyone! So I have a week and a half left in my bachelor's degree and, busy as I am, I'm stumped on a seemingly simple Access control. I'm an online student, and I'm having a bit of trouble hearing back from the professor. So I'm here for a lil boost In my report, it lists two categories and gives totals for those categories. Now I want to get a total of the two categories, but I can't get it on its own footer. As of now, it prints in two places, below each category total. If I use the page footer, I get an error message, so I assume I can't use it there (been a long time since I've used Access, and we didn't get much practice). I've tried messing with the grouping to add a new group, but then everything repeats, BAH! I'm getting stressed trying to continue aimlessly, so does anyone have a suggestion? I'm attaching a Word doc with 2 screenshots - one in design mode and one in layout mode. You'll see what I mean. Thanks a bunch!



    Attachment 712

  2. #2
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140
    Try the following in your Text Box's Control Source:

    Code:
    =DCount("[PKorFKFieldNameInRecordSource]","RecordSourceQueryName")
    Change the two different areas (above) accordingly.

    -RC

  3. #3
    babylikesburgh is offline Novice
    Windows Vista Access 2003
    Join Date
    Feb 2010
    Posts
    3
    How do I get it to show up only once, below the last category total? That's my problem, knowing where to put the total field by itself in that spot. Thanks!

  4. #4
    babylikesburgh is offline Novice
    Windows Vista Access 2003
    Join Date
    Feb 2010
    Posts
    3
    Nevermind - I figured it out. I placed it in the report footer, insteads of page footer, and it worked perfect Thanks again for your reply! I figured it was something super simple that I was complicating.

  5. #5
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140
    Sorry...just got back.
    Glad you were able to work it out.
    You're welcome!

    -RC

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

Similar Threads

  1. Query - using Max Totals with Criteria
    By mslieder in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:02 AM
  2. Report based on query shows no data
    By hbograd in forum Reports
    Replies: 2
    Last Post: 12-18-2009, 12:28 PM
  3. Replies: 1
    Last Post: 02-02-2009, 05:52 AM
  4. Problem with Report Based on a Query
    By gmalaret in forum Reports
    Replies: 1
    Last Post: 11-25-2008, 08:38 AM
  5. query - totals
    By mslieder in forum Access
    Replies: 0
    Last Post: 02-22-2006, 06:11 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