Summary Report
in [Reports]
|
From: Summing multiple fields on a form on 11 Apr 2010 03:33 I have a table that stores daily totals which user inputs in a form. I created a report (with a parameter query) allowing user to input the beg and end date for the report. The daily totals are summed and displayed on report. My question is how do I create a summary report by month that displays totals by months since I am not storing totals in a field in the table. Ex....report shows date Field1 Field2 Field3 Total (used NZ) 7/1/09 10 12 5 27 7/2/09 5 1 2 8 Total for the month would be: Field1= 15 Field2= 13 Field3 would =35 Since the table holds daily totals how do I create a summary report for July, Aug, etc.
From: Allen Browne on 11 Apr 2010 10:44 Create a report based on this table. In the Sorting And Grouping pane, choose the date field, and indicate you want a group footer. You will have the choice to group by month. In the month group footer, just add a text box with Control Source of: =Sum([Field1]) -- 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. "Summing multiple fields on a form" <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message news:BE5BD5CD-D44D-4420-A5EE-675FC2EE9184(a)microsoft.com... > I have a table that stores daily totals which user inputs in a form. I > created a report (with a parameter query) allowing user to input the beg > and > end date for the report. The daily totals are summed and displayed on > report. > > My question is how do I create a summary report by month that displays > totals by months since I am not storing totals in a field in the table. > > Ex....report shows > date Field1 Field2 Field3 Total (used NZ) > 7/1/09 10 12 5 27 > 7/2/09 5 1 2 8 > > Total for the month would be: > Field1= 15 Field2= 13 Field3 would =35 > > Since the table holds daily totals how do I create a summary report for > July, Aug, etc. > >
From: Summing multiple fields on a form on 12 Apr 2010 00:01 Thank You Allen...... "Allen Browne" wrote: > Create a report based on this table. > > In the Sorting And Grouping pane, choose the date field, and indicate you > want a group footer. You will have the choice to group by month. > > In the month group footer, just add a text box with Control Source of: > =Sum([Field1]) > > -- > 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. > > > "Summing multiple fields on a form" > <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message > news:BE5BD5CD-D44D-4420-A5EE-675FC2EE9184(a)microsoft.com... > > I have a table that stores daily totals which user inputs in a form. I > > created a report (with a parameter query) allowing user to input the beg > > and > > end date for the report. The daily totals are summed and displayed on > > report. > > > > My question is how do I create a summary report by month that displays > > totals by months since I am not storing totals in a field in the table. > > > > Ex....report shows > > date Field1 Field2 Field3 Total (used NZ) > > 7/1/09 10 12 5 27 > > 7/2/09 5 1 2 8 > > > > Total for the month would be: > > Field1= 15 Field2= 13 Field3 would =35 > > > > Since the table holds daily totals how do I create a summary report for > > July, Aug, etc. > > > > > . >
|
Pages: 1 Prev: Headers vs details Next: Displaying multivalue field data in report |