🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.databases
Article #518

Help w/ filemaker Pro db construction

#518
From: Philip W. Giltner Jr.
Date: Fri, 18 Dec 1992 16:02
21 lines
1676 bytes
I'm using FileMaker Pro to make a Database for a large class of
students I'm teaching (abt 180 students). I've been able to make
several different layouts, for different purposes. The first layout is
an individual student's record, with comments on his different papers
& tests. The second layout is a record of who who has or hasn't handed
in a given work (using if(x,y)). The third one is the one that's
giving me trouble, and why I ask for help.

This third onI've included a grand total summary at the end of this
layout. In the summary, I've figured out how to make count of all the
grades issued,  but I also want to make count of a the total count of
grades of each kind of grade issued, where A is greater than 80, B
is between 70-79, c between 60-69, e between 50-59, and zero-to-e is
obviously zero to 49.  This has taken several days of my time to
figure out, & still no progress is shown. How do I define a field to
look at all the fields (called "Overall Grade") and count the number
in each category? Anyone?  Please respond directly, as I don't
subscribe to this Newsgroup. I appreciate it.

Phil Giltner					Dept of History
pgiltner@epas.utoronto.ca			Univ of Toronto
Technical Details
Message-ID: <1992Dec18.160227.18550@epas.toronto.edu>
Path: arc1-ca.pugleaf.net!sparky!uunet!elroy.jpl.nasa.gov!usc!cs.utexas.edu!torn!skule.ecf!epas!pgiltner

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.databases
Path: arc1-ca.pugleaf.net!sparky!uunet!elroy.jpl.nasa.gov!usc!cs.utexas.edu!torn!skule.ecf!epas!pgiltner
From: pgiltner@epas.utoronto.ca (Philip W. Giltner Jr.)
Subject: Help w/ filemaker Pro db construction
Organization: University of Toronto - EPAS
Distribution: na
Date: Fri, 18 Dec 1992 16:02:27 GMT
Message-ID: <1992Dec18.160227.18550@epas.toronto.edu>
Sender: news@epas.toronto.edu (USENET)
Nntp-Posting-Host: epas.utoronto.ca
Lines: 21