Dsum help required 2

[Moss100]

Hello,

I am trying to get a running total in my query

Below I am summing the CREDIT field from the table TRANSACTION and including records that are equal or less than the ID field.

This works fine.

RunningSumCredit: DSum("[Credit]","[Transaction]","[ID]<=" & [ID])


I would like to restrict the sum to records that contain the words "Rent Paid" in the NOTES field

I have tried the following, but its not working - please could someone show me where I am wrong?

RunningSumCredit: DSum("[Credit]","[Transaction]","[ID]<=" & [ID] AND ([notes]="RentPaid"))

Many thanks Mark

 

[Andrzejek]

Try something like:
[tt]
RunningSumCredit: DSum("Credit","Transaction.ID <= " & ID & " AND Transaction.notes = "RentPaid")
[/tt]

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[dhookom]

RentPaid should be quotes within quotes so use either:

RunningSumCredit: DSum("[Credit]","[Transaction]","[ID]<=" & [ID] & " AND [notes]='RentPaid'")

or

RunningSumCredit: DSum("[Credit]","[Transaction]","[ID]<=" & [ID] & " AND [notes]=""RentPaid""")

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[Moss100]

Many thanks indeed