Sum Unbound Field in Form Footer - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Sum Unbound Field in Form Footer

Mathias Perle

4 months ago

I am currently trying to sum an unbound field in the footer of an endless form in Microsoft Access.
A value from a query is assigned to the field depending on whether a date falls within a certain period.
The database is my personal project management tool. i try to display and monitor my workload across multiple project
over a period of time. My attempts with multiple sum formulas like: =Sum([txtProjectDate]) or =Sum(Nz(Iff([txtGanttStart]>=[ActualStartDate] Und [txtGanttStart]<=[ActualEndDate];[txtRPLRequest];0);0)) have not been entirely successful. Perhaps my approach is completely wrong.
I hope the community can help me. i am grateful for any advice. Thank you!

	Alex Hedley @Reply 4 months ago
What shows on the Form?

	Mathias Perle OP @Reply 4 months ago

	Mathias Perle OP @Reply 4 months ago
It only shows #Error (#Fehler in german)

	Kevin Robertson @Reply 4 months ago
What is the name of the field you are trying to sum? What is the EXACT formula you are using?

	Mathias Perle OP @Reply 4 months ago
Fieldname i try to sum: txtProjectDate1 (it is not a date, it is a number formatted as percentage) Sum field name: =Sum([txtProjectDate1]) (it is also not a date, it is a number formatted as percentage) The field names are not optimal, i will correct that after i found a way to build the sum :-) So both fields has the same type.

	Mathias Perle OP @Reply 4 months ago
txtProjectDate1 is unbound. Because of that, i think the sum function will not work.

	Richard Rost @Reply 3 months ago
You're correct that the Sum function in a form footer only works with fields that are actually bound to your data source, not with unbound controls. To sum calculated or unbound values, you'll usually want to move that calculation into your underlying query or use VBA to loop through the records and total them up.

	Alex Hedley @Reply 3 months ago
DSum

	Mathias Perle OP @Reply 3 months ago
Thank you so much for your support. So i have to change my approach. I have no glue how to do it but i will try to find out. Thank you!

	Richard Rost @Reply 3 months ago
Just take those same calculations and put them in a query if you can. Then you can sum them up in the form, because they exist in the underlying query.

	Richard Rost @Reply 3 months ago
You're in today's QQ video. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View