Help! How to create a balance query

[tanxinrong]

Hi, there are few purchasers and all of them have quota. I record every transaction and now I need to know their balance quota.

I try this at first, then I realize it deduct all purchase from every clinic. I want it to show the balance for each individual purchaser (clinic) without having to type the clinic name in the critera (I have so many purchaser I cannot create a single query for everyone of them)


Balance (Methadone 1): [Pembeli]![Quota Methadone 1]-DSum("[Kuantiti permit unit]","[Belian]","[Category] = 'Methadone 5 mg/ml Syrup'")



Then I do this

Balance (Methadone 1): [Pembeli]![Quota Methadone 1]-DSum("[Kuantiti permit unit]","[Belian]","[Category] = 'Methadone 5 mg/ml Syrup'" And "[Alamat Pembeli]='" & [Alamat Pembeli] & "'")

But the value like this....http://imgur.com/a/Z5JrM

Anyone can help me? Thanks. I know this sounds stupid, but I'm sure there is another way to do this.

[ssanfu]

I am not really sure what you are asking but maybe this close.
You had extra double quotes around the AND.

This is wrong:

"[Category] = 'Methadone 5 mg/ml Syrup'" And "[Alamat Pembeli]='" & [Alamat Pembeli] & "'"

Try this:

Balance (Methadone 1): [Pembeli]![Quota Methadone 1]-DSum("[Kuantiti permit unit]","[Belian]","[Category] = 'Methadone 5 mg/ml Syrup' And [Alamat Pembeli]='" & [Alamat Pembeli] & "'")

[tanxinrong]

Yes this solved my problem.