Hi all,
I am using Access database and through VBA Coding I retrieve results of a SQL query into Excel.My problem is when I use a SQL Query with GROUP BY claus I get an error similar to
[Microsoft][ODBC Microsoft Access Driver]You tried to execute a query that does not include the specified expression 'Companyname' as part of an aggregate function.
But the same Query without GROUP BY clause works without any error.I dont know what the problem with GROUP BY clause is.Can someone help me?
And another problem I am facing is with the pivot tables.
When I include a calculated field(unitprice*Quantity) in the data field of the pivot table the total I get is usually greater than expected . That is the the calculated fields are duplicated and the total exceeds what is expected. Can some one help me with this?