Group By

[Allan]

Is there a way to take a DatasheetView Form, and have it do a "GroupBy" like
I can in a Report?

I am trying to make an interactive scheduling form, whereby I can have a
PivotTable-like form contain combo boxes. If I can Group By "Class times" on
the left column, I should be able to put the Class Location on the top row
headings. Then I can fill in the grid with combo boxes to select classes.

Surely someone has done this before.... Anyone?

Allan
Alberta, Canada

 

[Emilia Maxim]

Is there a way to take a DatasheetView Form, and have it do a "GroupBy" like
I can in a Report?

I am trying to make an interactive scheduling form, whereby I can have a
PivotTable-like form contain combo boxes. If I can Group By "Class times" on
the left column, I should be able to put the Class Location on the top row
headings. Then I can fill in the grid with combo boxes to select classes.

Allan,

you could get the pivot table-like form with a crosstab query, but
such a query is not updatable and won't let you fill the grid. So I
guess the only workaround is to create a temporary table having the
structure you want to display and base a continuous form on this
table. You could then transfer the data into the 'real' tables when
the form is closed.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de