That Query doesn't make much sense I'm afraid.
You are specifying Expr1 as 'Open' , so assuming the rest of the criteria pull the correct details remove that from the Having clause.
You then refer to
Code:
AND (([Issue Header].[Order Level Status])="Open"));
But isn't that the field you have just "created" as Expr 1?
so assuming the rest of the criteria pull the correct details remove that from the Having clause as a start and see if that helps.
Also in SQL server strings are always surrounded by single quotes ' not " , so if you are doing this in SQL server management studio it would error out immediately.