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
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.
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.
Summary: 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 Bala...
Summary: I am building a MS Access form. In one of the fields, I want the user to specify a file on the hard drive, to be used later. How do I set the field up to allow the user to browse through the folders o...
Summary: I am packaging an application that I have wriiten in MS Access BUT I need to disable the F1 Key, in order that the Access Help does not pop up and also permanently disable the office assistant wizard ...