rudolfelizabeth
Programmer
How do you solve the following problem in a transaction query.
If you have three transactions for the same customner on the same date.
AliasBalcarryforwardruntotal2: DSum("Nz (Debit-credit,0)","transactions2","clientnumber=" & [clientnumber] & " and [Transdate]<=#" & Format([Transdate],"mm-dd-yyyy") & "#")
I used the above code but access used the same value on these date
I incorporate the id value it didnot work either you don't get the correct value for each date.
Another thing where do you find the macro setvalue command in access 2007
If you have three transactions for the same customner on the same date.
AliasBalcarryforwardruntotal2: DSum("Nz (Debit-credit,0)","transactions2","clientnumber=" & [clientnumber] & " and [Transdate]<=#" & Format([Transdate],"mm-dd-yyyy") & "#")
I used the above code but access used the same value on these date
I incorporate the id value it didnot work either you don't get the correct value for each date.
Another thing where do you find the macro setvalue command in access 2007
