Counting Field contents

[pbucc]

Hi there. i have a DB that has a list of contacts... name, address, city, state, country..... it's very simple. i'm trying to create a layout that has fields that will show all the contents and another one that will show the ammount or records.....

example:

500 records in total

then a field called "country list" and shows (or something like it)

250 in canada

250 in U.S.A

this would work with any field that i create it for....

i have about 2000 records to deal with.

thanx

[Matt Klein]

You need to use a sub-summary and a Grand Summary layout part. Setup a layout with a Header, Leading Grand Summary, and a Sub-summary when sorted by the Country field. Define a Summary field to count the Country field(don't select running total). Then, put the newly defined field in the Leading Grand Summary. Then, put the same field in the Sub-summary with the Country field to the left of the summary field. Then, enter the browse mode. Find the set of records you want to summarize and sort them by the Country field. Lastly, enter the Preview mode following the sort and you should have your numbers.

Hope this helps!