Article View: comp.sys.mac.databases
Article #366Re: FILEMAKER PRO AND ZIPCODE
From: Hades
Date: Fri, 16 Oct 1992 14:45
Date: Fri, 16 Oct 1992 14:45
16 lines
1294 bytes
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-
Technical Details
Message-ID:
<1992Oct16.144516.28266@dartvax.dartmouth.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!gatech!rpi!bu.edu!dartvax!coos.dartmouth.edu!hadesReferences:
<719218849.F00002@blkcat.UUCP>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!gatech!rpi!bu.edu!dartvax!coos.dartmouth.edu!hades From: hades@coos.dartmouth.edu (Hades) Newsgroups: comp.sys.mac.databases Subject: Re: FILEMAKER PRO AND ZIPCODE Message-ID: <1992Oct16.144516.28266@dartvax.dartmouth.edu> Date: 16 Oct 92 14:45:16 GMT References: <719218849.F00002@blkcat.UUCP> Sender: news@dartvax.dartmouth.edu (The News Manager) Reply-To: hades@Dartmouth.Edu Organization: Dartmouth College, Hanover, NH Lines: 16 Disclaimer: Personally, I really don't care who you think I speak for. Moderator: Rec.Arts.Comics.Info