in pricing small building jobs, one often has a total field for the
page, known as the "page total"

i'm using fm for one of these jobs and want to have page totals

is it feasible to get FM to total just what's on a page ?

ptarmigan

In article
<8ef6686c-7241-4b68-af6e-d915c21fb785@b1g2000hsg.googlegroups.com>,
Ptarmigan <thdyoung@googlemail.com> wrote:

> in pricing small building jobs, one often has a total field for the
> page, known as the "page total"
> 
> i'm using fm for one of these jobs and want to have page totals
> 
> is it feasible to get FM to total just what's on a page ?
> 
> ptarmigan

FileMaker has no idea what a "page" is. 

It really depends on how you are already creating those "pages". If you
already have pages split (eg. perhaps all records for one date are on
the same page, then all records for the next date start on a new page,
etc.) then you can simply add a Sub-summary Part to the Layout ... BUT,
FileMaker will not stick to one page, so if there are more records than
fits on a page the "page" sub-total will simply appear at the end of
those records, which may well be on the second page.

WIf you are not already creating individual "pages", then what you
would have to do is work out how many records you can fit to a page,
then set-up a script to loop through giving each record the appropriate
page number (ie. 1 for the first X records, 2 for the next X records,
etc.). Then you can have a Layout that displays and sub-totals each
page by first sorting the records by this new "page number" field.

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

thank you Helpful Harry

I can see that FM has no concept of a "page"

I guess I'll do what lots of people do - adapt the task to my
understanding of what the computer can do

ptarmigan