Run Time error '-2147217887(80040e21)'

[aman1234]

Hi All
I am getting the following error message in strsql:
You tried to execute a query thats does not include the specified expression 'ScanDate=20140730 and SCanhour=8' as part of an aggregate function in the following strsql.

Please Login or Register  to view this content.

[nathansav]

Your scan hour isnt in the group by, so i think the scan hour should be a where, not having.

Where is the query selection, Having is the result of aggregation, so having sum(x)=20 is the result of 20, WHERE x=20 will only sum when x=20

This is a SQL issue.

[aman1234]

Thanks nathansav. It worked fine.