Count Field Values

[mkruter]

I'm sure there is a really good reason why sub-summary fields only work in preview mode but I need that functionality in browse mode so that I can manipulate the data and easily see the record I choose in form mode. It will be a working list.

I have many businesses and would like to list them by category and then alphabetically. In preview mode I can not only do this but also have a heading before a group of advertisers listing what category they are in and a count field that tells me how many businesses are in that category. Perfect!

In browse mode I can also organize the list by grouping the businesses by category simply by sorting by the category field first, just as I would on my report. However, I now have to have the category listed next to each business as opposed to just listing the category above the group of businesses. My first question is if anyone knows of a visible workaround for this. A way to get browse mode to visually mimic preview mode.

My second, more important, question is how I can get a total of each category type? Perhaps a field that calculates all the total of each variable in the category field or perhaps, even better, a field that i can place on my footer that calculates the total value of that field based on the selected record. The footer would also show other info about the chosen record. I do not want to have to have the field selected for it to count.

Thank you,

Marc

Edited January 30, 2008 by Guest

[Søren Dyhr]

Turn to this template:

http://www.kevinfrank.com/download/kf-fast-summary.zip

The second question should be covered by watching this movie:

--sd

[mkruter]

1. While the Kevin Frank example seems nice I'm not sure how it applies to me.

2. The video, which I have seen before, is talking about summary fields in PREVIEW mode. As I stated, I already know how to do that. I would like to create a summary field that operates in BROWSE mode.

[Søren Dyhr]

You need to organize your solution utilizing the various flavors of summary fields, the templates get's the data from the summary fields via GetSummary( and assembles the summary in a text field.

Again doesn't generalized question make us aim particular well, perhaps you should upload us a template you wish to get the summary from. And we should then be able make the required alterations to make it behave, provided you havn't neglected other hints made here regarding relational structure.

Anyways, I've changed Kevins approach slightly - take a look if it should be in the vicinity of what you wish?

--sd

fast_summaryModSD.zip