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!

 

[Pat Hartman]

Here is a debugging hint:
When you have to construct strings, use a variable to hold them. That way, if there is a problem, you can add a stop in the code and print the string to the debug window. You will almost always see the error

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