Computing.Net > Forums > Programming > Reporting in MS Access

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Reporting in MS Access

Reply to Message Icon

Name: imtiaz
Date: January 30, 2004 at 07:33:58 Pacific
OS: win 2000
CPU/Ram: 128
Comment:

Hi Friends
I need a report in MS Access (related Banking System) for any customer.
My Fields are
1) Date
2) Debit Amount
3) Credit Amount
4) Balance


My problem is this that I could not find the Balance after every transaction in report.Please help me. I will be very thankful to you.




Sponsored Link
Ads by Google

Response Number 1
Name: altaylor
Date: January 30, 2004 at 08:10:26 Pacific
Reply:

If you are basing the report on a query, an easy way to get the balance is to create a new field in your query with a field heading along the lines of:

Balance: [CreditAmount]-[DebitAmount]

This will give a positive or negative result depending on the amounts. Use this field in your report against each transaction.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Reporting in MS Access

Reporting in MS Access www.computing.net/answers/programming/reporting-in-ms-access/9225.html

Browse Hard Drive in MS Access Form www.computing.net/answers/programming/browse-hard-drive-in-ms-access-form/9857.html

Disabling F1 Key in MS Access www.computing.net/answers/programming/disabling-f1-key-in-ms-access/10224.html