Running Totals

[Rebeca]

Hi, bear with me, I'm not a novice, but far from an expert.

I have a database that I have setup that 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 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

 

[Wayne-I-M]

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.

Are you using a "running sum" (from the properties box) on the report as a
whole of just on the group?

If you are running the sum just on the group you can select this option from
the properties

 

[Rebeca]

I am using it just on the group. The AR Balance field is populated in my
Physician Header. I've tried moving it into the Data Detail section and the
totals still will not work properly. I'm guessing that I need to use
something like DSum, but I'm not sure of how.