Great Day, I have created a report that displays the revenue that a vehicle repair shop has made on servicing its customers' vehicles. The fields look something like this:
InvoiceDate
Cost of Parts
Tax
Service Cost
Misc. Cost
And then it sums these fields on each vehicle and each customer, since a customer can have more than one vehicle. Then it does a grand total for the report. For aesthetics I have placed the text boxes for the above referenced fields in the JobID Header (RepairOrder), and I am placing the total fields for the vehicle in the YearMakeModel footer and the total fields for the customer in the Customer Footer. In the JobId footer(repair order) I have the following control source for summing the Cost of parts field…
=Sum([txtPartsTotal])
and so forth for the other fields. txtPartsTotal is the field that grabs the sum total of parts used from a subreport. However, when the form opens (rptCustomerRevenue), a dialogue box is requesting the I enter a parameter value for txtPartsTotal, although txtPartsTotal displays the appropriate number.
I would greatly appreciate if someone can tell me why I am getting these parameter requests.
Thanks in advance.
r/David
Tidak ada komentar:
Posting Komentar