Qry not returning all records

[Guest]

I am trying to get this to give me all the categories in the LEBAEst_Cost I
have tried a number of things in the list first, last, sum, where etc and I
don't know enough about SQL/VBA to fix the problem. This report is
calculating a number of things right but it is not giving me ALL of the
records in the LEBAEst_Cost table.
Can anybody help?

SELECT qryPurchaseOrderRpt.ProjectID, qryPurchaseOrderRpt.CategoryID,
qryPurchaseOrderRpt.CategoryName, qryPurchaseOrderRpt.MainCatID,
qryPurchaseOrderRpt.MainCatName, [EST_S-84a].LEBAEst_Cost,
Sum(qryPurchaseOrderRpt.ExtendedPrice) AS SumOfExtendedPrice
FROM [EST_S-84a] INNER JOIN qryPurchaseOrderRpt ON [EST_S-84a].Category =
qryPurchaseOrderRpt.CategoryID
GROUP BY qryPurchaseOrderRpt.ProjectID, qryPurchaseOrderRpt.CategoryID,
qryPurchaseOrderRpt.CategoryName, qryPurchaseOrderRpt.MainCatID,
qryPurchaseOrderRpt.MainCatName, [EST_S-84a].LEBAEst_Cost
HAVING (((qryPurchaseOrderRpt.ProjectID) Like [What Project ID?
Example:LEBA] & "*"));

 

[Pat Hartman\(MVP\)]

Inner Joins return only records that have data in both tables. You may need
to change the join type to Left instead of Inner.

 

[Guest]

I changed that but it still isn't giving me all of the records. The budget

Inner Joins return only records that have data in both tables. You may need
to change the join type to Left instead of Inner.

I am trying to get this to give me all the categories in the LEBAEst_Cost I
have tried a number of things in the list first, last, sum, where etc and
I
don't know enough about SQL/VBA to fix the problem. This report is
calculating a number of things right but it is not giving me ALL of the
records in the LEBAEst_Cost table.
Can anybody help?

SELECT qryPurchaseOrderRpt.ProjectID, qryPurchaseOrderRpt.CategoryID,
qryPurchaseOrderRpt.CategoryName, qryPurchaseOrderRpt.MainCatID,
qryPurchaseOrderRpt.MainCatName, [EST_S-84a].LEBAEst_Cost,
Sum(qryPurchaseOrderRpt.ExtendedPrice) AS SumOfExtendedPrice
FROM [EST_S-84a] INNER JOIN qryPurchaseOrderRpt ON [EST_S-84a].Category =
qryPurchaseOrderRpt.CategoryID
GROUP BY qryPurchaseOrderRpt.ProjectID, qryPurchaseOrderRpt.CategoryID,
qryPurchaseOrderRpt.CategoryName, qryPurchaseOrderRpt.MainCatID,
qryPurchaseOrderRpt.MainCatName, [EST_S-84a].LEBAEst_Cost
HAVING (((qryPurchaseOrderRpt.ProjectID) Like [What Project ID?
Example:LEBA] & "*"));