Yeah definitely confused now, are you saying replace the WHERE line like below, I'm getting a 'Syntax Error'
Code:
SELECT Left([Location],2) AS Expr1, Right([Location],1) AS Expr2, Opus.*
FROM Opus
WHERE Expr1 = [Enter Aisle] AND (Expr2 = [Enter Level] OR Expr2 = Switch([Enter Level]="A", "G", [Enter Level]="B", "H", True, [Enter Level]))
UNION SELECT Left([Location],2) AS Expr1, Right([Location],1) AS Expr2, Wrigley_Res.*
FROM Wrigley_Res
WHERE Expr1 = [Enter Aisle] AND (Expr2 = [Enter Level] OR Expr2 = Switch([Enter Level]="A", "G", [Enter Level]="B", "H", True, [Enter Level]))
UNION SELECT Left([Location],2) AS Expr1, Right([Location],1) AS Expr2, Glenmark_SAP.*
FROM Glenmark_SAP
WHERE Expr1 = [Enter Aisle] AND (Expr2 = [Enter Level] OR Expr2 = Switch([Enter Level]="A", "G", [Enter Level]="B", "H", True, [Enter Level]))
UNION SELECT Left([Location],2) AS Expr1, Right([Location],1) AS Expr2, Wrigley_Act.*
FROM Wrigley_Act
WHERE Expr1 = [Enter Aisle] AND (Expr2 = [Enter Level] OR Expr2 = Switch([Enter Level]="A", "G", [Enter Level]="B", "H", True, [Enter Level])));