Summary Report

  • Thread starter Thread starter Summing multiple fields on a form
  • Start date Start date
S

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.
 
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"
 
Thank You Allen......

Allen Browne said:
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.
Click to expand...
.
Click to expand...
 
Back
Top