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]))
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]))