How to sum by week

[Pierre van Male]

Hi,

I have a table registering activities' logs with date and duration (stop time - start time). This log table is related to a main table.

I would like to create a portal in the main table that makes a sum of the duration by week and by activity:

Activity-1

|----------------------------------|

|year weeks Sum of duration |

|2004 15 20:35 |

|2004 16 18:54 |

| etc. |

|----------------------------------|

With Access, this kind of stuff is very easy to create (with a query), but with FileMaker... Should I create a new table that would be filled up by a script or do you know a better way to achive that?

Thanks in advance for your help!

Pierre

[Ugo DI LUCA]

Hi,

Are there multiple logs per day/week in your related file, which would mean you're looking for a "summary portal" with one line per week ?

Also, you're talking "tables". Are you using 7 ?

[Pierre van Male]

We are using FM 5. I didn't know the "summary portal" feature and I will check that.

So, there is multiple logs per week in the related file (not per day, yet it could occur in the future).

I also would like to print the "summary portal" in the main file... Do you think that is possible?

Thanks for your help!

Pierre