Does anybody know how to do sorting and grouping in a Microsoft Access form? I need to present data on a form very much like I would in a report -- but I can not find any type of functionality to allow me to group data.
I have several tables that produce the "common" data elements about an event. For simplicity of communication, I will refer to this entire collection of tables as the header_info. I have another table with a 1 to many relationsip holding additional detail elements (will call this table detail). I want to produce a form that lookes like this:
<Form Header>
general form stuff, along with controls and such
<Detail>
header_info.EventName header_info.StartDate header_info.EndDate header_info.MoreInfo
detail.activity detail.description detail.revenue
<Form Footer>
more general form stuff and controls
When the form is opened, I want it to group data (just like what a report will do using "Sorting and Grouping", so that the resulting form looks like this:
<Form Header>
general form stuff, along with controls and such
<Detail>
Super Truck Event June 12, 2009 June 14, 2009 Monster Rally Truck Stomping
Opening Day Trucks on display $200
First Heat Trucks crushing cars $500
Second Day Second heat races $500
Johnsonville Fair July 4, 2009 July 4, 2009 One day event sponsored by town hall
Oldies Band The Mamas & Papas $1500
Fireworks 20 minute display $20000
FOA conferance Aug 22, 2009 August 29, 2009 Farmers of America Conferance
Workshop 1 Agricultural advances $6000
Workshop 2 Pest control $6000
Workshop 3 Raising market value $6000
Workshop 4 A better potato $6000
<Form Footer>
more general form stuff and controls
I tried using the SQL "group by" in my underlying query, but this did not do anything. I've also looked around for a "Sorting and Grouping" in the menu bar and properties -- no luck there either (unless I am blind).
Start Free Trial
