Forum Discussion
Sum If from subform based on criteria in main form
Hello, I am attempting to create a Sum If formula from my subform based on criteria in my main form (year). The year will change when the main form changes (based on ProjectCode), so I want to set t...
Hi,
In order to understand the problem:
- Where do you try these expressions? In the Controlsource of a textbox in the subform?
- Is the year a criterion for whether the calculation should be performed at all, or should it filter the records for the total?
- What are the results you get with your attempts?
- Let us see the real expression without paraphrasing it. Only then we have a chance to see if the syntax is ok.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK