total sum in group

[Guest]

I have a report made that seperates everything by month, this is working fine.

But when I make a sum of the group, it adds things up by date. So if I have
2 or 3 days of a month with data, it gives me the total for each. What I am
trying to do is make a grand total of the entire month.

I hope this makes sense. I appreciate your help.

 

[Marshall Barton]

I have a report made that seperates everything by month, this is working fine.

But when I make a sum of the group, it adds things up by date. So if I have
2 or 3 days of a month with data, it gives me the total for each. What I am
trying to do is make a grand total of the entire month.

I hope this makes sense.

Have you tried using a text box with an
=Sum([field to total])
expression in the month group footer?

If that won't do what you want, then please explain the
report's groups and how the total should be calculated.

 

[Guest]

Have you tried using a text box with an
=Sum([field to total])
expression in the month group footer?

If that won't do what you want, then please explain the
report's groups and how the total should be calculated.

Yes, that is what I am doing, but not getting what I need.

I have a forecasting report that gives me the list of material I will need
to order over the course of the year.

It is grouped by material identification, then by month. However, in that
month it may say I need the same material for 3 different parts on 1 day, and
for 2 different orders on a different day, and on and on.

So, when I run the report it says in May I need a ceartain amount of
material for all the parts I need to have thoughout the month, but when I run
a =sum([field name]) it gives me a sum for each day, rather than the entire
month.

It is reading the date in the table, instead of only the month, or
something???

Thanks for your reply, I hope this makes more sense and you can help me. I
have tried everything and I am lost.

 

[Marshall Barton]

Have you tried using a text box with an
=Sum([field to total])
expression in the month group footer?

If that won't do what you want, then please explain the
report's groups and how the total should be calculated.

Yes, that is what I am doing, but not getting what I need.

I have a forecasting report that gives me the list of material I will need
to order over the course of the year.

It is grouped by material identification, then by month. However, in that
month it may say I need the same material for 3 different parts on 1 day, and
for 2 different orders on a different day, and on and on.

So, when I run the report it says in May I need a ceartain amount of
material for all the parts I need to have thoughout the month, but when I run
a =sum([field name]) it gives me a sum for each day, rather than the entire
month.

It is reading the date in the table, instead of only the month, or
something???

What you're describing sounds like you have a group for a
date field with the Sum text box in the date group footer.
The Sum text box for the month needs to be in month group
footer.

Either that or there are some details about your report that
I don't understand yet. I am assuming that your table is
properly normalized and that you do not have separate fields
for each day of the week or month or some such abnormal
structure.

 

[Guest]

Thanks for all your help Marsh, that did it!

KJ