Grouping in Form?

[SF]

I have a form in access 2007 that show the follwing:

FY Type Male Female Total
07 Forum 11 55 66
07 Campaign 50 10 60
08 Forum 10 55 65
08 Campaign 10 10 20

Can I add a grouping so that the form will show as the follwing:

FY Type Male Female Total
07 Forum 11 55 66
07 Campaign 50 10 60
Total 07 61 65 126

08 Forum 10 55 65
08 Campaign 10 10 20
Total 08 20 65 85

SF

 

[Allen Browne]

You cannot apply grouping in a form like that.

You can filter a form to the current year. Alternatively, you could use 2
subforms: one filtered to the current year, and the other to the previous
year.

Or you could use a report.

 

[Peter Hibbs]

SF,

A Flex Grid Control will 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.

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

HTH

Peter Hibbs.