Solved Running Sum with two numeric criteria (1 Viewer)

[JAQ]

Hi There,

Not very smart with access coding,

here is my Dsum where i stuck i need dsum with two numeric field criteria like

I have fileds like

CNNO numeric customer no field
INNO numeric invoice number field

i have created this; and working well but need customer ID (CNNO) criteria as well that will be aded as "And" but i am unable to write that

Val(DSum("[credit]","payments","inno=" & [inno]))

 

[Gasman]

Show your attempts?

 

[JAQ]

Val(DSum("[credit]","payments","inno=" & [inno]))

it was my attemp which is working but i need one more criteria with CNNO (Customer number)

 

[GaP42]

Try:
Val(DSum("[credit]","payments","[inno]=" & [inno] & " AND [cnno] = " & [cnno]))

 

[Gasman]

Not sure why you feel you need the Val() function?

 

[JAQ]

Try:
Val(DSum("[credit]","payments","[inno]=" & [inno] & " AND [cnno] = " & [cnno]))

Thats worked !!! thanks

 

[Pat Hartman]

You ABSOLUTELY do not need the Val() function. Val() is a string function and DSum() returns a numeric value. Val() is used to select leading numeric characters from a string.