I am trying to create a report using three different tables, with a one to many relationship. If I just create the query I get the records repeated a number of times.
What I am looking for: At the top of the report Customer name, address etc... Next I would like to show the labor costs for the job, could be one row could be twenty. Next I would like to show material costs, again could be one or twenty rows. At the bottom I would like to have a grand total line showing Total sale price, total labor, total material, labor and material as a percentage of sale price.
Do I need to create three seperate reports, then create a single report with three subreports?
Thank You
Joe Lawn
jtlawn@hotmail.com
What I am looking for: At the top of the report Customer name, address etc... Next I would like to show the labor costs for the job, could be one row could be twenty. Next I would like to show material costs, again could be one or twenty rows. At the bottom I would like to have a grand total line showing Total sale price, total labor, total material, labor and material as a percentage of sale price.
Do I need to create three seperate reports, then create a single report with three subreports?
Thank You
Joe Lawn
jtlawn@hotmail.com