Hello again.
I am trying a different approach.
I have two Custom Views, Custom Materials and Custom Labour, which shows the following code.
Material Table.__
select `Title`,
`Job_No`,
`Quantity`,
`Unit_Price`,
`Additional_Cost`,
`Description`,
Quantity * Unit_Price + (Quantity * Unit_Price * Additional_Cost / 100),
(Quantity * Unit_Price * Additional_Cost / 100 + Quantity * Unit_Price)*0.175
From `material`
Labour Table**
select `Job_No`,
`Engineer_Name`,
`Paying_Rate`,
`Account_ID`,
`Working_Hrs`,
`Sheet_Returned`,
Paying_Rate * Working_Hrs,
Paying_Rate * Working_Hrs * 0.175
From `labour`
One the Custom Views, everything works fine, and I have set up the TOTALS, and it is better that way as some clients will only want to view a Materials Invoice, or a Labour invoice.
But, Is there a way I can just grab the TOTALS from the two custom views and put into a new custom view???
Cheers
Paul.
