    
"create view q5 as select sdate, product, price, Sum(quantity) AS SumOfquantity, Sum(valu) AS SumOfvalue, branch" _
        & " FROM Data GROUP BY sdate, Product, price, branch ORDER BY branch"
         
You tried to execute a query that does not include the specified expression 'sdate' as part of an aggregate function.
 
       
  