Great Day, I have an Report that prints an invoice, and the Report has a
subreport that displays repair items and costs. There could be more than
one repair item with the associated cost, and then I sum the total of all
repair items. There may be an instance where one (or more) of the repair
items is marked as "N/C" for No Charge. There is a Yes/No field that marks a
repair item as N/C in the form that creates the repair order (Invoice). I
load that field in the report as unseen, and I have a text box next to the
cost of the repair item that says..
=IIf([txtNoCharge]=-1,"N/C"," ")
Now jumping back to the report, I show the totals of the repair service:
Cost of Labor
Cost of Parts
Tax
Misc.
Total cost of job (adds to above)
What I would like to do is add a field after Misc. that sums all of the
fields in the subreport where the service item was provided at no charge,
and this figure will be subtracted from the other costs to show the
discount. It would seem that I could filter the form to sum only NoCharge
items, but the form is already filtered for RepairItems.
Any suggestions will be greatly appreciated.
r/David
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar