DSum multiple criteria

[hillbilly]

Hello guys, I try since hours to get this query running:

DSum("GewichtungBereich";"qryReportGattungBereiche";"IDB=" & [IDB] & " Und IDG=" & [IDG])

I'm thankfull for any advice! Cheers

 

[theDBguy]

Hi. Welcome to AWF!

Maybe try using "AND" instead. Just a guess...

DSum("GewichtungBereich";"qryReportGattungBereiche";"IDB=" & [IDB] & " AND IDG=" & [IDG])

 

[hillbilly]

Thanks for the welcome! It did work (my access runs in german, so mosty 'Und' instead of 'AND' works, but I better continue with english grammar! Thank you very much and greetings from snowy Switzerland

 

[theDBguy]

Thanks for the welcome! It did work (my access runs in german, so mosty 'Und' instead of 'AND' works, but I better continue with english grammar! Thank you very much and greetings from snowy Switzerland

Hi. Glad to hear you got it sorted out. Good luck with your project. I wasn't sure if code works in other languages too. Cheers!