Double Date and calculation

  • Thread starter Thread starter CJM3407
  • Start date Start date
C

CJM3407

Ok, so I have a report that uses a query that checks a 30 day period, and
puts information on every day even if there was no activity on that day. It
builds this query with an Activity table and a Date table(has all dates from
now to 2050) and joins them. Problem is when I get two activities on the
same date, it counts them as two entries, which it should.

In the report:
But the problem shows up when I calculate interest everyday(more of every
entry). So it calculates/adds the interest twice on one day. I am new to
access, is there a way that i can like tell it to calculate interest on a
entries with similar dates one time. I tried a simple groupOn activity
date, but then I wasn't getting my running total for deposits and withdrawals
across the 30 days. It would only do for the entries that are grouped. So,
I need to be able to group the entire thing and put a balance(for the date)
summing and then each day has a single interest calculation. What is the
best way to nest the grouping or do something a lot simpler and I just don't
know about it.
 
Ok, I have it somewhat working. In my report I grouped by date and I have a
DateOf Footer. My Balance is tracking correcty. Then inside the footer I
calculate the interest for the total balance. Where access crashes is when I
say to do a Running total inside the footer of the interest calculated. It
makes sense when I do the calculation inside detail like normal it works
fine(but it calculates the interest multiple times depending on the amount of
activities for the day).
 
Correction: I just got the interest to do a running total. But It is when I
try to put in on the Report Footer is when it crashes. By just putting a
textbox down there and =[InterestCalc]
 
Back
Top