edo janssen
Registered User.
- Local time
- Today, 16:28
- Joined
- Oct 29, 2010
- Messages
- 16
I have a form on which plots are displayed by their owner. When you change a plot it gets an enddate and a new plot is created with the new data. On the form I want to show the state from January the 1st of the past three years. I do this with DSum. However, if a plot has no end date it is not included in the calculation.
As you can see in the attachment, on 1-1-2010 there are 145,385 hectare, on 1-1-2011 there are 145,385 hectare and on 1-1-2012 there are 165,465 hectare. On the form the totals of 2010 and 2011 are displayed but the total of 2012 not.
Is there a way to add plots together? Note: it is possible that in one year some plot have an enddate and some have not, for example if there has been no change to the plot.
Who can help me out?
As you can see in the attachment, on 1-1-2010 there are 145,385 hectare, on 1-1-2011 there are 145,385 hectare and on 1-1-2012 there are 165,465 hectare. On the form the totals of 2010 and 2011 are displayed but the total of 2012 not.
Code:
=DSum("[TotaalHectare]";"qryPerceelEigenaar2";"[Eigenaar_id]='" & Formulieren!frmPerceelEigenaar!Klant_id & "' And [Wijzigingsdatum]< #" & Formulieren!frmPerceelEigenaar!Begindatum0 & "# And [Einddatum]> #" & Formulieren!frmPerceelEigenaar!Einddatum0 & "#")
Is there a way to add plots together? Note: it is possible that in one year some plot have an enddate and some have not, for example if there has been no change to the plot.
Who can help me out?