Subtotal in Report - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Subtotal in Report

Lori Kozlowski

3 years ago

Hi,
This is probably simple but I am having trouble figuring out how to add a subtotal in a report.
I have a list of clients attending the event but they are 2 different companies. Everything is in one table: client name and RSVP total. I just need to total them by company in 2 text boxes in the report so I can see how many from each company make up the total RSVPs.

	Kevin Robertson @Reply 3 years ago
Grouping Then add a textbox to the Group Footer and add a Sum function as the Control Source.

Lori Kozlowski OP @Reply

3 years ago

Hi Keven, thanks. I am kind of new to this so I am not sure if I know how to do that or not. I think I may have watched the video on that. I can get the total of company A and company B using the sum function. When I try to put their individual totals in the text box it goes wrong. I keep getting a syntax error. I tried using a query result or a new table and I am just making myself confused. I am trying to teach myself and I think I am missing something or don't understand something I need. I appreciate any help you can offer.

	Dan Jackson @Reply 3 years ago
DSum

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View