sql-access: HAVING clause and != operator
Posted
by every_answer_gets_a_point
on Stack Overflow
See other posts from Stack Overflow
or by every_answer_gets_a_point
Published on 2010-05-12T02:15:30Z
Indexed on
2010/05/12
2:24 UTC
Read the original article
Hit count: 378
i am new to access sql and i built a select statement that looks like this:
SELECT [Lab Occurrence Form].[Practice Code],
Count([Lab Occurrence Form].[1 0 Preanalytical (Before Testing)]) AS [CountOf1 0 Preanalytical (Before Testing)],
[Lab Occurrence Form].[1 0 Preanalytical (Before Testing)]
FROM [Lab Occurrence Form]
WHERE ((([Lab Occurrence Form].[Occurrence Date]) Between #9/1/2009# And #9/30/2009#))
having ([CountOf1 0 Preanalytical (Before Testing)] != 0)
GROUP BY [Lab Occurrence Form].[Practice Code], [Lab Occurrence Form].[1 0 Preanalytical (Before Testing)];
its not liking my HAVING clause. what is wrong with it? how do i do a != ??
© Stack Overflow or respective owner
