(no subject)

I'm having some trouble writing a particular reportbuilder report.

What I want to do is to list, for a particular job, list the total in-house
operations cost and hours, the total subcontract cost and hours, and the
total cost of materials. I am using JobOper to pull the Operations costs,
linking it to the JobHead, the master table, by Jubnum.

This works fine, until I try to link the materials table to JobNum. When I
do so, I get duplicate operation entries, one duplicate for every material

Am I using the wrong master table? Is there any way to get a materials
total cost on the same Reportbuilder Report with operations total cost?

Thanks in advance for your help.

Best regards,