Sum of certain outputs in a continuous form

[Akchayan]

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?

[CJ_London]

Use an aggregate query

Group by Abwesenheitsgrund
Sum Abwesenheit_in_Tagen

[Akchayan]

Use an aggregate query

Group by Abwesenheitsgrund
Sum Abwesenheit_in_Tagen

But the query is not just these 2 columns. There are more, so it doesnt work with a aggregate query.
The query consists of 3 different tables.

[CJ_London]

Create a new query based on your query for the aggregates

[Akchayan]

Create a new query based on your query for the aggregates

I dont really understand how that works, but is there no way doing that in the form itself?

[CJ_London]

if you just want holidays you could use the dsum function

=Dsum("Abwesenheit_in_Tagen","myQuery","Abwesenheitsgrund='Ferien'")

replace myQuery with the name of the recordsource for your form

or perhaps try

=Summe(iif([Abwesenheitsgrund]="Ferien",[Abwesenheit_in_Tagen],0))

or maybe

=-Summe([Abwesenheit_in_Tagen]*[Abwesenheitsgrund]="Ferien")

[Akchayan]

if you just want holidays you could use the dsum function

=Dsum("Abwesenheit_in_Tagen","myQuery","Abwesenheitsgrund='Ferien'")

replace myQuery with the name of the recordsource for your form

or perhaps try

=Summe(iif([Abwesenheitsgrund]="Ferien",[Abwesenheit_in_Tagen],0))

or maybe

=-Summe([Abwesenheit_in_Tagen]*[Abwesenheitsgrund]="Ferien")

Thank you very much it worked with the Dsum function.