Variable concatenation woes on DSum

[newbieX]

I know I have quotes or something like that in the wrong order but where? I've spent hours on this one line.

CustID = "ABD-33-JJPP"

APPLE_TOTAL = Nz(DSum("[FRUITtotal]", "tbl_FRUIT", "[FRUIT] = 'Apple' AND [BRAND] = 'Pink Lady' AND [Customer] = '" & CustID & "'))"

I get the following error:

Compile error:
Expected: list separator or )

Why? I hate concatenating variables. I can never get it right. Arrrrgggghhhhhh



I want to total all the pink lady fruit that the variable CustID ordered.

[ssanfu]

You're going to slap yourself.........You have the last double quote in the wrong place. Should be inside the 2 closing parentheses.

Try:

Nz(DSum("[FRUITtotal]", "tbl_FRUIT", "[FRUIT] = 'Apple' AND [BRAND] = 'Pink Lady' AND [Customer] = '" & CustID & "'"))

Expanded, it looks like

Nz( DSum("[FRUITtotal]", "tbl_FRUIT", "[FRUIT] = 'Apple' AND [BRAND] = 'Pink Lady' AND [Customer] = ' " & CustID & " ' " ) )

[newbieX]

Yes. And thanks for coloring coding response so I could wrap my head around it better.