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