Solved Summing in reports

[donkey9972]

Okay, now that I have my aesthetic boxes problem essentially solved with lots of help from the forums and with thanks to ArnelGP stepping in to help. I have a new question. How do you sum in a report? This report will need to sum the total for each month. I have 2 controls on my report titled 1A and 1B. I need the total for all entries for lets say 1-31 Dec 2024 to appear in a totals control for 1A and another for 1B. Then when the next month rolls around the count starts at 0 until there are numbers entered for 1-31 Jan 2025, same for Feb etc...

 

[June7]

Use =Sum([fieldname}) in a textbox in header or footer section.

 

[donkey9972]

I tried that, it is just saying #Error

 

[June7]

You need to show report query and exact expression used in textbox. Again, can provide file.

 

[donkey9972]

What I have on the report here.

 

[June7]

Aggregate functions cannot reference controls, only fields from recordsource.
=Sum([1A])
=Sum([1B]}

 

[donkey9972]

I even made sure the report had the table as the record source and I still received an error from where I am trying to get the total.

 

[June7]

Sorry, must be in report or group header/footer, not page.

I see you are using VBA approach and not the query I suggested.

All dates are displayed. Didn't you want to hide ones without data?

 

[donkey9972]

Yes, I am still working on that.

 

[donkey9972]

Ok, so my location was wrong, that solved that problem. Thank you.