Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by deutz

  1. deutz

    Aggregate query across four related tables

    Thanks for your suggestion. In the mean time another SQL genius has come up with this solution which seems to produce the desired results ... SELECT tblClient.fldClientID, tblClient.fldClientName, A.SumOffldItemAmt AS Total, B.SumOffldPaymentAmt AS Paid FROM (tblClient LEFT JOIN (SELECT...
  2. deutz

    Aggregate query across four related tables

    Thanks PHV, I tried your solution but the Job amounts and Payment amounts returned are greater than the sum of what's in the tables so I'm getting inaccurate figures. I think it has something to do with grouping across four tables, creates some kind of cartesian product or something where...
  3. deutz

    Aggregate query across four related tables

    Hi and thanks in advance, (Using Access 2003) I'm trying to create a query that brings together job/payment data from 4 related tables and group by client. Table 1 tblClient has primary key as fldClientID and also has fldClientName Table 2 tblJob has primary key as fldJobID and foreign key...
See more

Part and Inventory Search

Back
Top