A
A Craig
I am trying to create a report that computes percentages.
In this report, the customer pays a percentage of the
gross less sales tax to our company. The customer has a
minimum they reach before our company gets a percentage. I
know how to total each of these fields. I can also
calculate the total due to our company. The problem is
that I would like to have a running total for each day's
sales showing the percentage due to us.
For example:
The customer has gross sales of $2,000.00. We receive 10%
(186.83) of the gross sales less sales tax ($1,868.29).
The customer does not begin paying percentage until he has
reached a minimum of $200. Meaning the customer keeps the
first $200 of the 10%. I need to be able to have a
running total of each day's sales. That way if all the
information isn't entered in a timely manner, we can see
what is due for each day.
Gross Net Our% Minimum Amount Due Us
$2000 $1868.29 186.83 $200 0 (not reached $200)
$2000 $1868.29 186.83 $173.76
I am just starting to learn VBA. Any suggestions would be
appreciated.
In this report, the customer pays a percentage of the
gross less sales tax to our company. The customer has a
minimum they reach before our company gets a percentage. I
know how to total each of these fields. I can also
calculate the total due to our company. The problem is
that I would like to have a running total for each day's
sales showing the percentage due to us.
For example:
The customer has gross sales of $2,000.00. We receive 10%
(186.83) of the gross sales less sales tax ($1,868.29).
The customer does not begin paying percentage until he has
reached a minimum of $200. Meaning the customer keeps the
first $200 of the 10%. I need to be able to have a
running total of each day's sales. That way if all the
information isn't entered in a timely manner, we can see
what is due for each day.
Gross Net Our% Minimum Amount Due Us
$2000 $1868.29 186.83 $200 0 (not reached $200)
$2000 $1868.29 186.83 $173.76
I am just starting to learn VBA. Any suggestions would be
appreciated.