I did end up figuring this out by the following:

select b.Name, a.Category, COUNT(a.OrderNumber) as 'Total Orders',

((sum(

CASE

WHEN b.UserID = a.EnteredUserID and c.OrdSourceID <> 'PROTOCOL'

THEN 1

ELSE 0

END) * 100 /...

Awesome - thank you! I did an 'open with Excel' and I can view it much better than a text file. I'll see if this will work for my...

Sorry I had no clue how that worked. OK, that did create a file. Is there a way to change the default file format? It saves it...

Actually I have done that. However when I select that, nothing happens.

AWESOME - thank you I think I got it to work!!!!!!!!