If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summary Report
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. |
#2
|
|||
|
|||
Summary Report
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" t.com wrote in message ... 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. |
#3
|
|||
|
|||
Summary Report
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" t.com wrote in message ... 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. . |
Thread Tools | |
Display Modes | |
|
|