Summary Report

[Summing multiple fields on a form]

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.

 

[Allen Browne]

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

Reply to group, rather than allenbrowne at mvps dot org.


"Summing multiple fields on a form"

 

[Summing multiple fields on a form]

Thank You Allen......

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

Reply to group, rather than allenbrowne at mvps dot org.


"Summing multiple fields on a form"

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.

.