Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #653

Re: Counting number of summary fields

Show all headers | View raw

On Feb 15, 3:07 pm, HelpfulHa...@BusyWorking.com (Helpful Harry)
wrote:
> In article
> <c0a4a9ae-f133-4d80-bce2-0e75d3a45...@m5g2000yqk.googlegroups.com>, David
>
>
>
>
>
>
>
>
>
> Feyrer <dfey...@feyrerobx.com> wrote:
> > On Feb 9, 12:16=A0am, HelpfulHa...@BusyWorking.com (Helpful Harry)
> > wrote:
> > > In article
> > > <f9b4cf89-f5dc-4c69-b781-85d5bec5b...@hb4g2000vbb.googlegroups.com>,
> > > David Feyrer <dfey...@feyrerobx.com> wrote:
>
> > > > This gives me the number of course attendees per class but what do I
> > > > do if students take more than one course?
>
> > > It was only an example of using Summary Fields, but it will work if each
> > > course a students is taking is a separate Record (e.g. in a related
> > > Enrolments Table).
>
> > > If the courses are stored in a Repeating Field or normal Text Field, then
> > > you've got a rather difficult job to try and summarise that and it can't
> > > be done using Summary Fields. Your best option would be really to change
> > > the database to use a related Enrolments Table.
>
> > > It's not possible to give an exact answer without knowing how your
> > > database is structured, how the data is stored, and what you want to
> > > obtain from it.
>
> > Harry,
>
> > I think you are correct, I need to redesign the data base around using
> > an enrollments table with courses being the multiple rather than the
> > way I have it now which is multiple students.  ? ? ?  Otherwise I need
> > to devise some fancy calculation.
>
> > David
>
> There are many ways of creating a database like this and it depends on
> what you need it to do, but the "normal" approach would usually be using
> three Tables, something like:
>
>      Students   <->   Enrolments   <->   Courses
>
> linked by ID codes (StudentsID and CourseID).
>
> The reports like the one you're trying to generate can be easily produced
> through the Enrolments Table, as can other reports like an attendee name
> list to give each course teacher.
>
> Helpful Harry   :o)

Harry,
Have already made the modifications,  thanks much.

David

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar

Thread

Counting number of summary fields David Feyrer <dafeyrer@gmail.com> - 2012-02-05 09:28 -0800
  Re: Counting number of summary fields HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-02-07 18:25 +1300
    Re: Counting number of summary fields David Feyrer <dfeyrer@feyrerobx.com> - 2012-02-08 06:29 -0800
      Re: Counting number of summary fields HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-02-09 18:16 +1300
        Re: Counting number of summary fields David Feyrer <dfeyrer@feyrerobx.com> - 2012-02-15 05:42 -0800
          Re: Counting number of summary fields HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-02-16 09:07 +1300
            Re: Counting number of summary fields David Feyrer <dfeyrer@feyrerobx.com> - 2012-02-16 04:52 -0800

csiph-web