Running Totals

R

Rebeca

I have a database that I have setup where users enter batch information to
log charges, payments and adjustments for medical practices.

I then have a query that displays the batch information by physician. In
this query, it shows the physician, the batch name, the charges, payments,
and all of the adjustment amounts and displays a total for each record.

I have brought this query into a report that groups the batch information by
date and correctly displays a running total per day and a grand total at the
end of the report. This report also displays a Beginning AR balance that it
pulls from another table that I have included in the above mentioned query.

I'm having a problem getting the running totals to display correctly. As
I've stated, it displays the daily totals in groups correctly, but instead
showing the running total as Beginning AR - Total1 - Total1, etc., it is
displaying Beginning AR - Total1 for each line. I know that this is something
relatively easy to fix, but I am stuck.

I am an extreme novice at VBA, so expect more questions if this is the
appropriate way to go. Any assistance is greatly appreciated!!!!

Rebeca
 

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

Running Totals 2
Please Correct My Error 1
DSUM Date Criteria 3
Incone & Expenses Statement 0
Grouping Issue 2
Report Help - Starting/Ending Balance 7
Final Problem - Running AR updates 2
Repeating data 4

Top