Hello,
I have a PO form (frmOrder) from tblOrder with a field (ProjectID) from (tblProjectCoding).
I have a query (qryProjectDetailForm) that pulls several fields from (tblProjectCoding) to show all my projects.
I then have a secondary query (qryProjectPurchases) which shows all purchases made under each project # with a totals column.
My problem is my query will only show projects that have had purchases made under them. How do i also show the projects that haven't had purchases made under them so they reflect $0 in the totals column.
i'm using these queries much deeper after this to show other data with other queries but this is the root cause of my problem.
I have a PO form (frmOrder) from tblOrder with a field (ProjectID) from (tblProjectCoding).
I have a query (qryProjectDetailForm) that pulls several fields from (tblProjectCoding) to show all my projects.
I then have a secondary query (qryProjectPurchases) which shows all purchases made under each project # with a totals column.
My problem is my query will only show projects that have had purchases made under them. How do i also show the projects that haven't had purchases made under them so they reflect $0 in the totals column.
i'm using these queries much deeper after this to show other data with other queries but this is the root cause of my problem.
Code:
SELECT QryProjectDetailForm.ProjectID, QryProjectDetailForm.ProjectName, Sum(qryOrderSubTotal.SumOfUnitTotal) AS ProjectSubTotal
FROM (QryProjectDetailForm INNER JOIN tblOrder ON QryProjectDetailForm.[ProjectID] = tblOrder.[ProjectCoding]) INNER JOIN qryOrderSubTotal ON tblOrder.[OrderID] = qryOrderSubTotal.[OrderID]
GROUP BY QryProjectDetailForm.ProjectID, QryProjectDetailForm.ProjectName;