>Without a GROUP BY clause, you can't have a HAVING clause. You could try adding the Timeitms.timeout constraint to the WHERE clause but this will still give you mulitple instances of Timehd.empid if there are multiple values >17.
Hi, Larry
I did have a Group By clause, but SQL Server handles it differently then Fox does, it always errors with something about Not having an aggregate function. But I didn't or Don't have an aggregate function in my Fox statement.
Thanks
Jon
Non-MVP Non-MCP Non-MCSE
Visual FoxPro, What else is there?