J
Jere Shaw
I created a small application primarily to print invoices for a small
business. The invoices work as expected. However, I am having a problem
creating another report that contains a calculated control in the report
footer section that should return a total for all records in one of the
fields. Allow me to explain.
The application has two tables: Job and Job Details in one- to- many
relationship. Among other fields, the Job table contains JobID, Name,
JobDate, and LaborCost fields. The Job Details table contains JobID,
PartDescription, PartPrice, and Quantity fields.
The report with the problem, which shows all records in the database, is
based on a query that contains fields from each table as well as a
calculated field. The report has several columns. One column is for
LaborCost and another is for PricePart. When I create a calculated control
in the report footer section of the report to total the PartPrice field all
works well. The LaborCosts, however, is a different matter. The calculated
control in the footer section that is suppose to total LaborCost returns a
value as if there is a labor cost for each PartPrice.
To explain further, one job has only one LaborCost but may have several
parts in the Job Detail table. For example, the LaborCost for a job may be
$200. If there are two parts, the calculated control in the report footer
section shows $400 in labor costs instead of $200. It doesn't matter if I
group the records or not.
Does anyone have a solution to my problem?
business. The invoices work as expected. However, I am having a problem
creating another report that contains a calculated control in the report
footer section that should return a total for all records in one of the
fields. Allow me to explain.
The application has two tables: Job and Job Details in one- to- many
relationship. Among other fields, the Job table contains JobID, Name,
JobDate, and LaborCost fields. The Job Details table contains JobID,
PartDescription, PartPrice, and Quantity fields.
The report with the problem, which shows all records in the database, is
based on a query that contains fields from each table as well as a
calculated field. The report has several columns. One column is for
LaborCost and another is for PricePart. When I create a calculated control
in the report footer section of the report to total the PartPrice field all
works well. The LaborCosts, however, is a different matter. The calculated
control in the footer section that is suppose to total LaborCost returns a
value as if there is a labor cost for each PartPrice.
To explain further, one job has only one LaborCost but may have several
parts in the Job Detail table. For example, the LaborCost for a job may be
$200. If there are two parts, the calculated control in the report footer
section shows $400 in labor costs instead of $200. It doesn't matter if I
group the records or not.
Does anyone have a solution to my problem?