Checkbook Report

R

Ray

I have a table that lists stores income and expenses. It looks somewhat like
this...

EntryDate Income Expense
1/1/07 85 0
1/2/07 0 55
1/3/07 0 20

I want to make a report that would look like this...

EntryDate Income Expense Running Balance
1/1/07 85 0 85
1/2/07 0 55 30
1/3/07 0 20 10

Any suggestions as to how to generate the Running Balance? Have made
hundreds of custom reports in past but this one stumps me. Am sure I am
overlooking the obvious. Cannot figure out the query either.
 
S

strive4peace

Hi Ray,

use a Report, not a Query.

Report controls have a *RunningSum* property ...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
R

Ray

Perfect!!!!

strive4peace said:
Hi Ray,

use a Report, not a Query.

Report controls have a *RunningSum* property ...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
Click to expand...
 
S

strive4peace

you're welcome, Ray ;) happy to help

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal Question with a twist 3
formula pulling data based on 1 input on another tab. 0
If Function 1
Running balance for debit and Credit using query in Access 2007 0
Report Help - Starting/Ending Balance 7
Time-shifting information 1
Running total by date 2
Excel 2007 Conditional formatting with number formats 3

Top