1 unique field from 3 tables


I'm building a job cost report and require the following on one row, with the unique ID being 'Cost Code code':-

  • Sum of 'Total Cost' from Job Ledger Entry table
  • Sum of 'Committed Amount' from Purchase Line table
  • Sum of 'Sub. Committed Amount' from Subcontract Order table

I only wish to see the cost code once with all three values against it.

This is obviously an additional module added on for construction but the methodology remains the same.


Please sign in to leave a comment.