Dsum filtering

[ICBSprod]

Hello!

I use a control containing the following DSum function in my form: (Norwegian character set)

=DSum("[Sum]";"QueryArbeidsdetaljer";"[ArbeidsavtaleID]=Forms!Arbeidsavtale!ArbeidsavtaleID")

Here my main form is "Arbeidsavtale" and my subform is "QueryArbeidsdetaljer"

In the subform I have a field named "Oppgaveområde"
Now I want to add a new control containing a Dsum fiunction on my form as above, but this time I only want it to sum the records from "Oppgaveområde" that contains the text "Kulturskole"
I guess I have to put in "Like Kulturskole" somewhere, but I have not any clue how to do it and where to put it.
Likewise I want a third control with a Dsum function that sums everything but "Kulturskole".
You may also take a look at the image I have attatched.
Can anyone help me?


Regards
Børge


Norway

[ItsMe]

Something like this should work.

"[ArbeidsavtaleID]=Forms!Arbeidsavtale!ArbeidsavtaleID AND [Oppgaveområde] Like '"Kulturskole"'"

"[ArbeidsavtaleID]=Forms!Arbeidsavtale!ArbeidsavtaleID AND [Oppgaveområde] Not Like '"Kulturskole"'"

Remember that each Dsum(), Domain function, is taking a trip to the data to do your calculation. You may experience better performance grabbing a RecordsetClone of your subform and using the RecordsetClone to do the math. This alternative method requires some VBA code.

[ICBSprod]

Exellent!
Thank You very much!
I think I will take a closer look at the RecordsetClone, but for now, I am happy.
Thanks!