Syntax to use variable in DSum()

[Budatlitho]

Hello:

I have this function in Access VB:

Public Function JumbulaTotals()
Dim db As Database
Dim rs As Recordset
Dim eid As Long
Dim strSql As String
Dim amountdue As Long
Dim amountpaid As Long
eid = 1049523

amountdue = DSum("[Order amount]", "Jumbula", _
            "[MemberID_1] =1049523")
            Debug.Print "Order amount = " & amountdue

It executes OK, but when replacing 1049523 as the criteria value with the variable eid,

            "[MemberID_1] = eid")

I get
run-time error '2471'"


The expression you entered as a query parameter produced this error:
'eid'

Obviously, it's a syntax error but I've tried many additions of brackets and punctuation with no success.
Groan!

[Gicu]

Try:

amountdue = DSum("[Order amount]", "Jumbula", _
            "[MemberID_1] =" & eid)
            Debug.Print "Order amount= " & amountdue

Assumes eid is numeric, if text you wrap it in single quotes (or double double-quotes):

amountdue = DSum("[Order amount]", "Jumbula", _
            "[MemberID_1] =""" & eid & """")
            Debug.Print "Order amount= " & amountdue

Cheers,

[Welshgasman]

You need to learn how to concatenate variables.
Use a variable to store the criteria. Then you can debug.print it until you get it correct, then use that variable in the function.

[Budatlitho]

Eureka! Thank you.

[Budatlitho]

Thanks. Will do. Any reference material online?

[Welshgasman]

My first point of call is always Google.

https://www.google.com/search?q=conc...e-gws-wiz-serp