Simple question I am sure, but need to create a field that shows the
running total of the records display, but not the numerical total - I
need the field to contain the sequence total of each character value of
the particualar summary field.  For instance, each record of five
records has a serial number starting at 1. I need the summary field to
show, '1,2,3,4,5'.  Lame explanation, I know.  Any help/suggestions
would be appreciated. Dan

Could it be, that you're aiming in this direction???:

http://www.filemakerpros.com/SerialCat.sit

http://www.filemakerpros.com/Serialize_by_Category.zip

--sd

dcallaha@infionline.net (Dan) wrote in message news:<1ghmm0w.y1mf3a1ntjb8oN%dcallaha@infionline.net>...
> Simple question I am sure, but need to create a field that shows the
> running total of the records display, but not the numerical total - I
> need the field to contain the sequence total of each character value of
> the particualar summary field.  For instance, each record of five
> records has a serial number starting at 1. I need the summary field to
> show, '1,2,3,4,5'.  Lame explanation, I know.  Any help/suggestions
> would be appreciated. Dan

I'm not quite sure how this would help, as there are already values for
the particular field I want to summarize. These bases seems to use the
auto-serialize function with FM, if I understand correctly.  I know my
description was obtuse, but all I need is the ability to list in a
summary field all the values for a particular field, each separated by a
comma.  Thank you, however - dan


S?ren Dyhr <sdyhr@get2net.dk> wrote:

> Could it be, that you're aiming in this direction???:
> 
> http://www.filemakerpros.com/SerialCat.sit
> 
> http://www.filemakerpros.com/Serialize_by_Category.zip
> 
> --sd
> 
> dcallaha@infionline.net (Dan) wrote in message
> news:<1ghmm0w.y1mf3a1ntjb8oN%dcallaha@infionline.net>... > Simple question
> I am sure, but need to create a field that shows the > running total of
> the records display, but not the numerical total - I > need the field to
> contain the sequence total of each character value of > the particualar
> summary field.  For instance, each record of five > records has a serial
> number starting at 1. I need the summary field to > show, '1,2,3,4,5'.
> Lame explanation, I know.  Any help/suggestions > would be appreciated.
> Dan

In article <1ghmm0w.y1mf3a1ntjb8oN%dcallaha@infionline.net>,
dcallaha@infionline.net (Dan) wrote:

> Simple question I am sure, but need to create a field that shows the
> running total of the records display, but not the numerical total - I
> need the field to contain the sequence total of each character value of
> the particualar summary field.  For instance, each record of five
> records has a serial number starting at 1. I need the summary field to
> show, '1,2,3,4,5'.  Lame explanation, I know.  Any help/suggestions
> would be appreciated. Dan

I'm not sure I follow that "lame explanation" properly, but ...

Create a field "SerialField" which is set to the "serial number
starting" value. This will allow you to create a relationship within
the same file that groups together all records with the same "starting
number".

From that relationship you can count the number of records with the
same "serial number starting" value, 
ie.   NumRecords = Count(Relationship::SerialField).

This count can then be used for a Calculation Field with a Text result
something like this:

      Summary = Left(" 1,2,3,4,5,6,7,8,9", NumRecords * 2)


Helpful Harry                   
Hopefully helping harassed humans happily handle handiwork hardships  ;o)

In article <1ghnilr.xnn89140yg3mN%dcallaha@infionline.net>,
dcallaha@infionline.net (Dan) wrote:

>I'm not quite sure how this would help, as there are already values for
>the particular field I want to summarize. These bases seems to use the
>auto-serialize function with FM, if I understand correctly.  I know my
>description was obtuse, but all I need is the ability to list in a
>summary field all the values for a particular field, each separated by a
>comma.  Thank you, however - dan

How would this field change?  Does it work on a found set?  That is, do
you find your set, then observe the result in your ideal summary field? 
Or does it act as a "real" running total, in that the user is continually
creating new records, and the field changes with each one?

The reason I asked is that depending on behavior (both FM behavior and
user behavior) of the field and the ultimate use for its contents, if
other than monitor display, it might be easier to make the field a simple
global field and script its updating.

Steve Brown

<eyebrown@mindspring.com> wrote:

> In article <1ghnilr.xnn89140yg3mN%dcallaha@infionline.net>,
> dcallaha@infionline.net (Dan) wrote:
> 
> >I'm not quite sure how this would help, as there are already values for
> >the particular field I want to summarize. These bases seems to use the
> >auto-serialize function with FM, if I understand correctly.  I know my
> >description was obtuse, but all I need is the ability to list in a
> >summary field all the values for a particular field, each separated by a
> >comma.  Thank you, however - dan
> 
> How would this field change?  Does it work on a found set?  That is, do
> you find your set, then observe the result in your ideal summary field?
> Or does it act as a "real" running total, in that the user is continually
> creating new records, and the field changes with each one?
> 
> The reason I asked is that depending on behavior (both FM behavior and
> user behavior) of the field and the ultimate use for its contents, if
> other than monitor display, it might be easier to make the field a simple
> global field and script its updating.
> 
> Steve Brown

It would be observerd/used after a particular find and only needs to be
used once (the cummulative value is pasted into a program and the
corresponding records are printed out).

Helpful Harry <helpful_harry@nom.de.plume.com> wrote:

> In article <1ghmm0w.y1mf3a1ntjb8oN%dcallaha@infionline.net>,
> dcallaha@infionline.net (Dan) wrote:
> 
> > Simple question I am sure, but need to create a field that shows the
> > running total of the records display, but not the numerical total - I
> > need the field to contain the sequence total of each character value of
> > the particualar summary field.  For instance, each record of five
> > records has a serial number starting at 1. I need the summary field to
> > show, '1,2,3,4,5'.  Lame explanation, I know.  Any help/suggestions
> > would be appreciated. Dan
> 
> I'm not sure I follow that "lame explanation" properly, but ...
> 
> Create a field "SerialField" which is set to the "serial number
> starting" value. This will allow you to create a relationship within
> the same file that groups together all records with the same "starting
> number".
> 
> From that relationship you can count the number of records with the
> same "serial number starting" value, 
> ie.   NumRecords = Count(Relationship::SerialField).
> 
> This count can then be used for a Calculation Field with a Text result
> something like this:
> 
>       Summary = Left(" 1,2,3,4,5,6,7,8,9", NumRecords * 2)
> 
> 
> Helpful Harry                   
> Hopefully helping harassed humans happily handle handiwork hardships  ;o)

But this principled on a serial number being entered and there being a
serial relationship between each record, correct?  The values of the
field I want to summarize is imported into, with the values being all
unique but no sequential or otherwise relationship between each record.

In article <1ghoian.1xt5c4310dbbuoN%dcallaha@infionline.net>,
dcallaha@infionline.net (Dan) wrote:

> Helpful Harry <helpful_harry@nom.de.plume.com> wrote:
> 
> > In article <1ghmm0w.y1mf3a1ntjb8oN%dcallaha@infionline.net>,
> > dcallaha@infionline.net (Dan) wrote:
> > 
> > > Simple question I am sure, but need to create a field that shows the
> > > running total of the records display, but not the numerical total - I
> > > need the field to contain the sequence total of each character value of
> > > the particualar summary field.  For instance, each record of five
> > > records has a serial number starting at 1. I need the summary field to
> > > show, '1,2,3,4,5'.  Lame explanation, I know.  Any help/suggestions
> > > would be appreciated. Dan
> > 
> > I'm not sure I follow that "lame explanation" properly, but ...
> > 
> > Create a field "SerialField" which is set to the "serial number
> > starting" value. This will allow you to create a relationship within
> > the same file that groups together all records with the same "starting
> > number".
> > 
> > From that relationship you can count the number of records with the
> > same "serial number starting" value, 
> > ie.   NumRecords = Count(Relationship::SerialField).
> > 
> > This count can then be used for a Calculation Field with a Text result
> > something like this:
> > 
> >       Summary = Left(" 1,2,3,4,5,6,7,8,9", NumRecords * 2)
> 
> But this principled on a serial number being entered and there being a
> serial relationship between each record, correct?  The values of the
> field I want to summarize is imported into, with the values being all
> unique but no sequential or otherwise relationship between each record.

Sorry, I told you I probably didn't follow what you were saying
correctly. I thought "each record of five records has a serial number
starting at 1" meant the records has serial numbers like 1-1, 1-2, 1-3,
1-4, and 1-5 (ie. all start with 1, and other records might start with
2, 3, etc.)



> It would be observerd/used after a particular find and only needs to be
> used once (the cummulative value is pasted into a program and the
> corresponding records are printed out).

Since the numbers aren't sequential or have any other specific order to
them, and you only want the "summary" at particular times, then the
easiest way is to simply use a script that loops through the found
records appending each serial number to a Global field. Something along
the lines of:

    Set Field [gSerialList, ""]
    Go To Record/Request/Page [First]
    Loop
      Set Field [gSerialList, gSerialList & SerialNum & ","]
      Go To Record/Request/Page [Next, Exit After Last]
    End Loop
    Set Field [gSerialList, Left(gSerialList, Length(gSerialList) - 1)]

where:
      SerialNum is you Serial Number field
and   gSerialList is a Global Text field

The last Set Field line is there to simply remove the extra comma that
will be left on the end of the list.



Helpful Harry                   
Hopefully helping harassed humans happily handle handiwork hardships  ;o)

Helpful Harry <helpful_harry@nom.de.plume.com> wrote:

> In article <1ghoian.1xt5c4310dbbuoN%dcallaha@infionline.net>,
> dcallaha@infionline.net (Dan) wrote:
> 
> > Helpful Harry <helpful_harry@nom.de.plume.com> wrote:
> > 
> > > In article <1ghmm0w.y1mf3a1ntjb8oN%dcallaha@infionline.net>,
> > > dcallaha@infionline.net (Dan) wrote:
> > > 
> > > > Simple question I am sure, but need to create a field that shows the
> > > > running total of the records display, but not the numerical total - I
> > > > need the field to contain the sequence total of each character value of
> > > > the particualar summary field.  For instance, each record of five
> > > > records has a serial number starting at 1. I need the summary field to
> > > > show, '1,2,3,4,5'.  Lame explanation, I know.  Any help/suggestions
> > > > would be appreciated. Dan
> > > 
> > > I'm not sure I follow that "lame explanation" properly, but ...
> > > 
> > > Create a field "SerialField" which is set to the "serial number
> > > starting" value. This will allow you to create a relationship within
> > > the same file that groups together all records with the same "starting
> > > number".
> > > 
> > > From that relationship you can count the number of records with the
> > > same "serial number starting" value, 
> > > ie.   NumRecords = Count(Relationship::SerialField).
> > > 
> > > This count can then be used for a Calculation Field with a Text result
> > > something like this:
> > > 
> > >       Summary = Left(" 1,2,3,4,5,6,7,8,9", NumRecords * 2)
> > 
> > But this principled on a serial number being entered and there being a
> > serial relationship between each record, correct?  The values of the
> > field I want to summarize is imported into, with the values being all
> > unique but no sequential or otherwise relationship between each record.
> 
> Sorry, I told you I probably didn't follow what you were saying
> correctly. I thought "each record of five records has a serial number
> starting at 1" meant the records has serial numbers like 1-1, 1-2, 1-3,
> 1-4, and 1-5 (ie. all start with 1, and other records might start with
> 2, 3, etc.)
> 
> 
> 
> > It would be observerd/used after a particular find and only needs to be
> > used once (the cummulative value is pasted into a program and the
> > corresponding records are printed out).
> 
> Since the numbers aren't sequential or have any other specific order to
> them, and you only want the "summary" at particular times, then the
> easiest way is to simply use a script that loops through the found
> records appending each serial number to a Global field. Something along
> the lines of:
> 
>     Set Field [gSerialList, ""]
>     Go To Record/Request/Page [First]
>     Loop
>       Set Field [gSerialList, gSerialList & SerialNum & ","]
>       Go To Record/Request/Page [Next, Exit After Last]
>     End Loop
>     Set Field [gSerialList, Left(gSerialList, Length(gSerialList) - 1)]
> 
> where:
>       SerialNum is you Serial Number field
> and   gSerialList is a Global Text field
> 
> The last Set Field line is there to simply remove the extra comma that
> will be left on the end of the list.
> 
> 
> 
> Helpful Harry                   
> Hopefully helping harassed humans happily handle handiwork hardships  ;o)

Thank you, Harry - works very well.  Truly,  Dan