SSC Veteran - The reason I put the select statement in the OTime variable was to get the sum of total hrs. The current procedure only calculates total hours...

SSC Veteran - Thanks. That got rid of the syntax errors so I will test this out with data.

Thanks again....

Here is the error message I get:

Error 170: Line 17: Incorrect syntax near 'OTime'.

Line 19: Incorrect syntax near '>'.

I've seen other code with select statments inside a case statement so...

Yes - I am getting a syntax error and it is on the following part of the code.

It doesn't like the "OTime" and it doesn't like the ">" sign.

Thanks.

OTime =...

Thanks so much for taking the time to answer my question. That did it! Have a Happy Turkey Day! Jim

I would be taking out Where "dept = 56" code.