That's just fine govi. Whenever I ask questions in various forums I am always aware that, while it is nice to get a complete and correct answer, what is...

I got it govi! I needed to put the keyword END before the bracket in order to complete the CASE statement.

Thanks Again and have a great day,

Gerry Dyck

govi, It didn't work for me! I get a syntax error near ")" on the line with the first SUM on it.

When I get it working, I will be...

Wow govi, that was fast. Thank you very much. I will try this out. I was on the right track but getting frustrated! I was just attempting...