Grouping records in Access 2010 subform in Datasheet View
I know this can be done, but I don't remember how:
I need to group records in a subform in datasheet view, so that records with the same value in the grouping field will be displayed as one with the 'plus' sign to expand the containing records.
I tried doing it by SQL group by in the recordsource property, but it doesn't work. Any ideas?
I need to group records in a subform in datasheet view, so that records with the same value in the grouping field will be displayed as one with the 'plus' sign to expand the containing records.
I tried doing it by SQL group by in the recordsource property, but it doesn't work. Any ideas?
May be you can use pivot form?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The disadvantages of using SubDatasheets are:
1. They give your users direct, *Unlimited* access to the Raw table.
This means they can do whatever they like (Delete Record/Fields, change table properties, ...etc)
:-O
2. They are a drag on performance:
http://support.microsoft.com/kb/275085
1. They give your users direct, *Unlimited* access to the Raw table.
This means they can do whatever they like (Delete Record/Fields, change table properties, ...etc)
:-O
2. They are a drag on performance:
http://support.microsoft.com/kb/275085
ASKER
Thanks!
OK,
Did you note the disadvantages of using this approach...?
Did you note the disadvantages of using this approach...?
Start from here:
http://mymsaccessblog.blogspot.com/2008/02/my-treeview-project-episode-1-hello.html