|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 8th, 2005, 09:28 PM
|
|||
|
|||
How do I calculate an Average Daily Balance in Access?
I am required to find a daily average balance in an access database and am
lost. The data that is entered is not on a daily basis 
|
|
#2
September 8th, 2005, 09:36 PM
|
|||
|
|||
|
Without knowing the structure of your data and what type of number you are
trying to average, it would be very difficult for us to answer this. -- Rick B "JOhnDragt" wrote in message ... I am required to find a daily average balance in an access database and am lost. The data that is entered is not on a daily basis
|
|
#3
September 8th, 2005, 09:55 PM
|
|||
|
|||
|
I have 5 tables in the database. Deal: contains grooping ingormation,
Company: contains base information, Deposits: has amount and date of deposits, Distributions: has date and amount of payouts, and Fees-Earnings: has date and amount of fees charged and earnings received. I hope this helps. thanks "Rick B" wrote: Without knowing the structure of your data and what type of number you are trying to average, it would be very difficult for us to answer this. -- Rick B "JOhnDragt" wrote in message ... I am required to find a daily average balance in an access database and am lost. The data that is entered is not on a daily basis
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to calculate the average for a daily changing value? | healthcare executive 72 | General Discussion | 4 | June 26th, 2005 02:17 PM |
| calculate average hours and minutes | llstephens | Worksheet Functions | 3 | November 29th, 2004 11:04 PM |
| calculate average hours worked | llstephens | Worksheet Functions | 1 | November 24th, 2004 02:37 PM |
| How to calculate opening balance in a report | Yaqub ahmad | Setting Up & Running Reports | 0 | July 29th, 2004 11:07 AM |
| Calculate average... | Frank Kabel | Worksheet Functions | 3 | April 14th, 2004 01:31 PM |
Linear Mode
