Re: Aging report problem.
- From: "Bob Darlington" <bob@xxxxxxxxxxxxxxx>
- Date: Fri, 26 Oct 2007 20:05:28 +1000
Ron,
Are you basing your report on a query?
Have you applied a criteria like "Balance <> 0" to that query?
Perhaps you could post the SQL.
--
Bob Darlington
Brisbane
"Ron" <ronSPAMBLOCKINGwest777@xxxxxxxxxxx> wrote in message
news:9qaUi.15423$uE4.13993@xxxxxxxxxxx
Hi All,
I've got a client/transaction type of database where tblClient is linked
to tblTransactions via ClientID. The client table contains all clients
from day one. The transaction table contains all transactions from day
one (includes any purchases, labor charges, payments, adjustments) The
aging report I developed works fine, except...
For any client that owes money, it lists ALL the transactions for that
client. Or, it lists all the transactions for a client where the dates of
entry are between 2 dates I have the operator input. But I really want it
more open--I want it to list only transactions that haven't been
paid/adjusted yet regardless of some arbitrary date the operator can
input. So, I want a report go through the transactions and find the first
transaction where the balance is not equal zero and start there on the
aging detail.
Example would be where Jane Smith has had 22 transactions but the 1st 18
equal 0 and just happen to have happened prior to March 2007, so she's got
just 4 that she still owes money on, and that's all I want to show on the
aging report--transactions since March 2007. Then John James has had 6
transactions and all are still owed and they date back to June of
2006--all should appear on the aging. And Bill Adams has 11 transactions,
the 1st 9 of which equals 0 and the last 2, from Sept 2007 are still owed
and those should appear, the first 9 shouldn't. Follow?
How can I pull out only the "unresolved" transactions?
TIA,
ron
.
- References:
- Aging report problem.
- From: Ron
- Aging report problem.
- Prev by Date: Use active directory to control the access to .mdb file
- Next by Date: Access -> Visual Studio and the .Net Framework
- Previous by thread: Aging report problem.
- Next by thread: Editing Caption Property
- Index(es):
Relevant Pages
|
