| | |
|
|
|
opening balance - closing balance |
|---|
| message from Greg on 15 May 2004 |
On my report I want to have an opening balance signifying all transactions
up to the month selected
and detailed transactions for the month selected
and then a closing blance.
I'm perpelexed how to do this Anyone knows how the banks do it with
statement formatting?
suggestions, ideas welcome.
Greg
|
| Arvin Meyer replied to Greg on 15 May 2004 |
Use a group footer in a report grouping by the month.
|
| Greg replied to Arvin Meyer on 16 May 2004 |
DESCRIPTION DATE IN OUT BALANCE
Opening Balance 31-01-2004 200
DescriptA 02-02-2004 20 220
DescriptB 05-02-2004 5 215
DescriptC 17-02-2004 9 224
DescriptD 19-02-2004 8 232
DescriptE 22-02-2004 20 252
DescriptF 26-02-2004 12 230
Closing Balance 29-02-2004 230
So maybe the opening balance represents many months of transactions.
Any Ideas.
Greg
"Arvin Meyer" <a@m.com> wrote in message
news:uW2Y47oOEHA.1688@TK2MSFTNGP10.phx.gbl...
|
| Arvin Meyer replied to Greg on 16 May 2004 |
So use a lookup to 1 query which will get the start balance. Then a second
query to return only the month you wish. The property of the Balance text
box on the report itself can be set to Running Sun on the Data tab.
|
|
Archived message: opening balance - closing balance (MS Access Error Message)
