Report Filter

[wajidpharmacist007]

i have report based on query in which group is set to supplier name when i run the query grouping is also done on those records in which supplier name field is blank i want to make no group on those records in which supplier name field is blank and also want to skip supplier name in which "return" or " received" pharase is present

 

[theDBguy]

Hi,

Does your query have a criteria to exclude those groups? If not, try adding one.

 

[wajidpharmacist007]

how to add criteria in query
when i write "is not null" in query it does not work

 

[theDBguy]

Hi,

Please post the SQL statement for your query, so we can give you a hand.

 

[wajidpharmacist007]

SELECT [Inventory Transactions Extended].Inventory.ID, [Inventory Transactions Extended].Inventory.Item, Sum([Inventory Transactions Extended].[Actual Quantity]) AS [Current Stock], [Suppliers Extended].[Supplier Name]
FROM [Inventory Transactions Extended] LEFT JOIN [Suppliers Extended] ON [Inventory Transactions Extended].Supplier = [Suppliers Extended].ID
GROUP BY [Inventory Transactions Extended].Inventory.ID, [Inventory Transactions Extended].Inventory.Item, [Suppliers Extended].[Supplier Name]
HAVING ((([Suppliers Extended].[Supplier Name]) Is Not Null));