opening balance - closing balance

[Greg]

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]

Use a group footer in a report grouping by the month.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Greg]

But i don't want to see all other months. For example if user
selects Feb-2004 report should look like:

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]

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.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access