B
Beaner200
I have a report that is based on a query. The query is capturing the
TherapistID, class name, cost, PST, GST, pmnt type. The therapist is
required to pay the employer a percentage based on the type of credit card
used and if a debit card is used, then it is .13 per transaction. So... I
have all these calculations in the query and they work good.
In my report, I added a TotalFee calculation that adds together the CardFee
and the DebitFee. This works good.
The problem that I am having is with the DebitFee. The .13 is to be applied
per transaction. So, if I have an invoice with 2 or more items on it, then
my calcualtions are adding the .13 to each transaction.
Is there anyway that I can have access to apply the .13 to the first
transaction on an invoice number and not apply to any subsequent transactions
on the same invoice number?
Also.... in the same report, the class name and payment type are based on
list boxes in the table. When I open the report, the correct name is showing
on the report but the field is highlighted in black. Is there anyway to
remove the black from the field?
Thanks
TherapistID, class name, cost, PST, GST, pmnt type. The therapist is
required to pay the employer a percentage based on the type of credit card
used and if a debit card is used, then it is .13 per transaction. So... I
have all these calculations in the query and they work good.
In my report, I added a TotalFee calculation that adds together the CardFee
and the DebitFee. This works good.
The problem that I am having is with the DebitFee. The .13 is to be applied
per transaction. So, if I have an invoice with 2 or more items on it, then
my calcualtions are adding the .13 to each transaction.
Is there anyway that I can have access to apply the .13 to the first
transaction on an invoice number and not apply to any subsequent transactions
on the same invoice number?
Also.... in the same report, the class name and payment type are based on
list boxes in the table. When I open the report, the correct name is showing
on the report but the field is highlighted in black. Is there anyway to
remove the black from the field?
Thanks