I have an endless form which refers to a query.
I would like to have the total for the holidays. But there are different reasons for absence. That is, it should display in a text field how many days the reason for absence was "holidays". This should be displayed in a text field in this continuous form.$
Abwesenheitsgrund = reasons for absence
Abwesenheit_in_Tagen = absence in days
I tried it like this:
=Summe(Nz([Abwesenheit_in_Tagen]))
but then every absence is added
It should be 6, but it outputs 9.
How should i do that?