Group Data

[Sash]

My brain just isn't working today. Is there any way to group data on a form
(similar to what you can do on a report). I wanted to break out data on a
form and run subtotals for the user for each category.

 

[Maurice]

There's no way to group data on a form as you do on a report. What you could
consider is creating a continious form based on the data and in the form
header place a combobx which filters the data based on this combobox. Then
you place a textbox referring to the parameter entered via the combofilter
and try to create a subtotal based on that.

Just an idea...

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples. The third option on the menu has something similar
to what you are describing.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[Mark Andrews]

You can have a listbox that runs a query and displays some summary data such
as summaries for each category. Just make sure you refresh it if any detail
data changes.

Or how about a button to popup a simple form or report showing totals.

Just some ideas,
Mark
RPT Software
http://www.rptsoftware.com