SELECT MenuItems.MnsId, MenuItems.MnsDesc, MenuItems.SortKey, MenuItems.ActionType, MenuItems.CodeToRun FROM MenuItems WHERE (((MenuItems.Level)=1)) UNION ALL SELECT MenuItems.MnsId, "     :.....  " & MenuItems.MnsDesc, MenuItems.SortKey, MenuItems.ActionType, MenuItems.CodeToRun FROM MenuItems WHERE (((MenuItems.Level)=2) AND ((MenuItems.CurrentState)=1)) UNION ALL SELECT MenuItems.MnsId, "                  :.....  " & [MenuItems].[MnsDesc] AS Expr1, MenuItems.SortKey, MenuItems.ActionType, MenuItems.CodeToRun FROM MenuItems AS MenuItems_1 INNER JOIN MenuItems ON MenuItems_1.MnsId = MenuItems.SubId WHERE (((MenuItems.Level)=3) AND ((MenuItems.CurrentState)=1) AND ((MenuItems_1.CurrentState)=1))
ORDER BY MenuItems.SortKey;