Dsum multiple criteria (1 Viewer)

[irwan.dwise]

Hello my name Irwan from Indonesia, i have problem with with syntax, i try to make recapitulation of material for each contract, can anyone help, please.
Thanks and sorry if my english not good

DSum("Qty";"Detail Kontrak";" [Material]='Jointing Coldshrink Resin 300' And  [No Subkontrak]  =" & [Nomor Sub Pemesanan] & " ")

here i attach the screenshot of my databse relation

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[theDBguy]

Hi. Welcome to AWF!

I'm not sure, but using spaces in your field names could be adding to the problem.

 

[irwan.dwise]

Hi. Welcome to AWF!

I'm not sure, but using spaces in your field names could be adding to the problem.

Ok i Will try to modify the column name

 

[arnelgp]

you have space on your table name/query so enclose it in square bracket:

"[Detail Kontrak]"

 

[oleronesoftwares]

Any table or field name with double words spaced e.g detail kontrak should have an underscore between them.i.e detail_kontrak. Also @arnelgp suggestion should be applied

 

[pbaldy]

Welcome to AWF. I moved your thread to a more appropriate forum.

 

[azhar2006]

Expr1: DSum("Qty";"[Detail Kontrak]";"[Material]='Jointing Coldshrink Resin 300' And [No Subkontrak]  =" & [Nomor Sub Pemesanan] & " ")

As he told you (theDBguy) and (arnelgp) you have spaces and also the table name contains an underlined that must be in square brackets

 

[Gasman]

Expr1: DSum("Qty";"[Detail Kontrak]";"[Material]='Jointing Coldshrink Resin 300' And [No Subkontrak]  =" & [Nomor Sub Pemesanan] & " ")

As he told you (theDBguy) and (arnelgp) you have spaces and also the table name contains an underlined that must be in square brackets

Names with underscores do not need to be surrounded by square brackets.?
They are normally there so as not to use square brackets?

 

[azhar2006]

Names with underscores do not need to be surrounded by square brackets.?
They are normally there so as not to use square brackets?

You are correct, I meant that he should not put a ruler (space)