running totals in query

[techkenny1]

Hi all,
I need some input on this one please.
Ihave a table that holds account debits.
all the entries are associated with a field(AcctNo) for eg
Income = 4-1011, expenditure = 5-000. These are just examples.
I have this code in the query - Balance: CCur(qryRunSum("QDebits","debits",[debits],"tdeposit"))

If I want to view just say income then I have entered in the crieria line "4-1011.
This will show all the income. But the running total shows for all the entries in the table.
What I need is for the running total to only show by the acctno which is entered in the criteria in the query.
I could use an append query and update those items, but is this the way to do it.


Many thanks

 

[lameid]

qryRunSum is a user defined function from ...

thread702-1532301

Given that, can you post your SQL and query name?

It seems like the source of the problem is that you are not using the same criteria in your query and Qdebits although I do not have enough information to suggest a solution.