How do I calculate an Average Daily Balance in Access?

J

JOhnDragt

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

JOhnDragt

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
 
Top