Specifying greater than criteria for numerical values

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));
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top