0

1 unique field from 3 tables

Hi

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.

2 comments

Please sign in to leave a comment.