Query Displayes Blanks

arnel_gp 

Thank you for your help; here you go:

1. Sales Query is successful:

---SELECT [Sales Broad].[Profit Center], Sum([Sales Broad].Sales) AS SumOfSales
--FROM [Sales Broad]
--WHERE ((([Sales Broad].Date) Between [Forms]![Form3]![StartDate] And [Forms]![Form3]![EndDate]))
---GROUP BY [Sales Broad].[Profit Center];

2. Food Cost Query is successful:

---SELECT Sum([Invoice by Expensiture Type3].SumOfreceive_total) AS Cost
---FROM [Invoice by Expensiture Type3]
---WHERE ((([Invoice by Expensiture Type3].pg_credit)="COGS-No Perpetual Inv" Or ([Invoice by ---Expensiture Type3].pg_credit) Is Null));

3. Other Cost Query is failing:

---SELECT [Invoice by Expensiture Type3].pg_credit, Sum([Invoice by Expensiture ---Type3].SumOfreceive_total) AS OCost
---FROM [Invoice by Expensiture Type3]
---GROUP BY [Invoice by Expensiture Type3].pg_credit
---HAVING ((([Invoice by Expensiture Type3].pg_credit)<>"COGS-No Perpetual Inv" And ([Invoice by ---Expensiture Type3].pg_credit) Is Not Null));