Select JobAct.OurInvID, JobHeads.JobID, JobHeads.LabourID, ; SUM( jobheads.Quantity) as Booked, SUM( jobact.hours) as Charged, ; Labour.Text ; from jobheads ; INNER JOIN JobAct ; ON jobheads.JobID = jobact.JobID ; INNER JOIN Labour ; ON Jobheads.LabourID = Labour.ID ; Where jobheads.JobID = "RTvo" ; and not EMPTY( JobAct.OurInvID) ; group by JobAct.OurInvID, jobheads.JobID, JobHeads.LabourID ,Labour.Text ; order by JobAct.OurInvID, jobheads.JobID, JobHeads.LabourID ; into cursor JobsS>I'm trying to achieve the report below:
> Derek Bob Angus ... >Inv. No. Booked Charged Booked Charged Booked Charged >_____ ______ _______ ______ _______ ______ _______ >1 0.75 0.75 >2 6 5.5 12 11 >3 20.5 20.5 >... >>
>Select JobAct.OurInvID, JobHeads.JobID, JobHeads.LabourID, ; > SUM( jobheads.Quantity) as Booked, SUM( jobact.hours) as Charged, ; > Labour.Text ; > from jobheads ; > Where jobheads.JobID = "RTvo" ; > and not EMPTY( JobAct.OurInvID) ; > INNER JOIN JobAct ; > ON jobheads.JobID = jobact.JobID ; > INNER JOIN Labour ; > ON Jobheads.LabourID = Labour.ID ; > group by JobAct.OurInvID, jobheads.JobID, JobHeads.LabourID ,Labour.Text ; > order by JobAct.OurInvID, jobheads.JobID, JobHeads.LabourID ; > into cursor JobsS >>