There's more to experience when you log in!
Then try and replace with just SUM( job_item.job_item_quantity * contract_boq.contract_rate) Estimated_Value
Contract and Systems Engineer
Cheshire West and Chester Council
Tel: 01244 9 77941
Location: Guilden Sutton Highways Office, Guilden Sutton Lane, Chester CH3 7EX
Excellent. Glad to be of assistance.