How do I calculate an Average Daily Balance in Access?

G

Guest

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
 
R

Rick B

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.
 
G

Guest

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
 

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

Calculate interest amount based on average daily balance 1
Calculating Average Daily Balances 1
Average Daily Balance 3
how do i calculate exponential moving average in microsoft access 1
Average Daily Balance 5
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Query/Reports - looking to get averages from data base 4
Max & Min Dates 0

Top