How do I calculate an Average Daily Balance in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
Access Running Balance in Access 1
Query/Reports - looking to get averages from data base 4
Query Help: Average of Columns Per Row 2
Max & Min Dates 0

Back
Top