C
Cecilia
I have the following SQL for a query. The query returns all values and does
not limit it to those greater than 1. Anyone have any ideas???
SELECT [Ships & On Hands].UPC, [Ships & On Hands].[Item Desc 1], Sum([Ships
& On Hands].[Range 2 POS Qty]) AS [SumOfRange 2 POS Qty], Count([Ships & On
Hands].[Range 1 Curr Str On Hand Qty]) AS [CountOfRange 1 Curr Str On Hand
Qty]
FROM [Ships & On Hands]
GROUP BY [Ships & On Hands].UPC, [Ships & On Hands].[Item Desc 1]
HAVING (((Count([Ships & On Hands].[Range 1 Curr Str On Hand Qty]))>1));
not limit it to those greater than 1. Anyone have any ideas???
SELECT [Ships & On Hands].UPC, [Ships & On Hands].[Item Desc 1], Sum([Ships
& On Hands].[Range 2 POS Qty]) AS [SumOfRange 2 POS Qty], Count([Ships & On
Hands].[Range 1 Curr Str On Hand Qty]) AS [CountOfRange 1 Curr Str On Hand
Qty]
FROM [Ships & On Hands]
GROUP BY [Ships & On Hands].UPC, [Ships & On Hands].[Item Desc 1]
HAVING (((Count([Ships & On Hands].[Range 1 Curr Str On Hand Qty]))>1));