DataSetHelper SelectGroupByInto

G

Guest

I am trying to modify the DataSetHelper method InsertGroupByInto to include
two fields in the group by clause, for instance I add EmployeeDept as a
column and try to group by EmployeeID, EmployeeDept. Code is giving errors.

dsHelper.InsertGroupByInto(ds.Tables!OrderSummary, ds.Tables!Orders,
"EmployeeID, EmployeeDept, count(Amount) Orders,sum(Amount)
OrderTotal,max(Amount) BestOrder,min(Amount) WorstOrder", "", "EmployeeID,
EmployeeDept")

What needs to be changed in the helper class to allow the group by of more
than one field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does DataSetHelper support grouping by MULTIPLE columns? 5
Access Crah on a query, 2
Query of customers who spent $x last year 4
Calculate Days between dates of a sale for a particular product 2
query with procedure 1
can't add row to ms access table 19
can't add row in code to access mdb 1
can't create new rows by code 1

Top