FILEMAKER PRO AND ZIPCODE

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Billy Krahl Thu, 15 Oct 1992 18:00

#364

Author: Billy Krahl
Date: Thu, 15 Oct 1992 18:00

15 lines
951 bytes

There are about 500 members in my user group, with each record
consisting of name and address.  I would like to create a detailed
printout listing the unique zipcodes and the count of member's zip
that match the unique zipcode.  An example of printout would be like:
    Zipcode       Count
    -------       -----
     20850         34
     20874         11
     20877         48
     20879         33
      :            :
For every instance of zipcode 20850 in Filemaker Pro database, the count
would be incremented.  Is there any way I can do it other than creating
a new field for each unique zipcode and put in calculatin...?
Thanks for any help.

Re: FILEMAKER PRO AND ZIPCODE

#366

Author: Hades
Date: Fri, 16 Oct 1992 14:45

16 lines
1294 bytes

Billy.Krahl@f421.n109.z1.fidonet.org (Billy Krahl) writes:

>For every instance of zipcode 20850 in Filemaker Pro database, the count
>would be incremented.  Is there any way I can do it other than creating
>a new field for each unique zipcode and put in calculatin...?

    Yup they are called Summary fields. What you do is create a field
called Zip Count or something, and designate it as a summary field that
performs a count. Then you sort by zipcode and put in a sub summary part
in a layout with this field in it, and it will count up the records in
each zipcode breakdown.

--
-Hades (Brian V. Hughes) 
  "I'm sorry, I didn't have my hearing aid on. Could you repeat that?"
			  -Admiral Stockdale-

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads