I have a transactions table and a balance table that look something
like this:
tblTransactions
TransactionID (PK Autonumber)
ClientID
TransactionDate
TransactionAmount (currency field, values must be >0)
CRDR (indicates whether the transaction is a (credit or debit)
StatementDate (Date stamp applied when the =93Statement=94 re****t is run)
tblAccountBalance (no PK in this table)
ClientID
AccountBalance (currency field can be >0 or <0)
BalanceDate (Date stamp applied when the =93Statement=94 re****t is run)
My goal is to have a re****t that shows the following:
Opening balance
Transactions for this period
Closing balance
When I run the re****t, I apply a date stamp to the =93StatementDate=94
field of each row in tblTransactions where the StatementDate is either
null or within the statement period. That works fine.
But I am getting mixed up with when to apply the date stamp to the
=93BalanceDate=94 field in tblAccountBalance. Rather than go into detail
about all of the permutations that are slo****ng around in my head, can
someone reassure me that my approach thus far is correct (or at least
workable) and give me a ****ge in the right direction.
Thanks
Paul
