Grand total in report footer? in Access Database Reports    |   |  Help   Search For:     In:   Office   Access Database     Access Database General Questions     Access Database New users     Access Database design     Access Database Forms     Access Database Forms Coding     Access Database Import/Export Data     Access Database Install and Configure     Access Database Macros     Access Database Programming     Access Database Queries     Access Database Reports     Access Database Security              Rose 4/25/2007 5:13 PM PST   Question   In doing a report, can you perform a grand subtotal of records by a category? For example if you have 50 records of people who served in the military and 1 field categorizes them by Soldier, Sailor, Marine or Airmen (But you do not want to sort by this field). Can a grand total be created in the report footer that shows me how many are in each category? -- Rose     Was this post helpful to you?         Reply |   Top           Allen Browne 4/25/2007 7:20 PM PST   Answer   So you want to provide *another* summary of the data at the end of the report? Use a subreport in the Report Footer section. The subreport's Record Source will be a query that groups and counts as desired. It's all very straight forward unless you will be filtering the main report. If so, the problem is to filter the subreport the same way. Simplest solution is to use a form where the user enters the limiting criteria in text boxes, and to refer to those text boxes in both queries (i.e. the main report's query and the subreport's query.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Rose" <Rose@discussions.microsoft.com> wrote in message news:8ED04501-9F43-4436-A40D-02D6E13276E5@microsoft.com... > In doing a report, can you perform a grand subtotal of records by a > category? > > For example if you have 50 records of people who served in the military > and > 1 field categorizes them by Soldier, Sailor, Marine or Airmen (But you do > not > want to sort by this field). Can a grand total be created in the report > footer that shows me how many are in each category? > > -- > Rose     Was this post helpful to you?         Reply |   Top           Rose 4/25/2007 8:38 PM PST   Many Thanks, it worked. -- Rose "Allen Browne" wrote: > So you want to provide *another* summary of the data at the end of the > report? > > Use a subreport in the Report Footer section. The subreport's Record Source > will be a query that groups and counts as desired. > > It's all very straight forward unless you will be filtering the main report. > If so, the problem is to filter the subreport the same way. Simplest > solution is to use a form where the user enters the limiting criteria in > text boxes, and to refer to those text boxes in both queries (i.e. the main > report's query and the subreport's query.) > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > "Rose" <Rose@discussions.microsoft.com> wrote in message > news:8ED04501-9F43-4436-A40D-02D6E13276E5@microsoft.com... > > In doing a report, can you perform a grand subtotal of records by a > > category? > > > > For example if you have 50 records of people who served in the military > > and > > 1 field categorizes them by Soldier, Sailor, Marine or Airmen (But you do > > not > > want to sort by this field). Can a grand total be created in the report > > footer that shows me how many are in each category? > > > > -- > > Rose > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies