Pierre van Male Posted June 30, 2004 Share Posted June 30, 2004 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 Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted June 30, 2004 Share Posted June 30, 2004 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 ? Link to comment Share on other sites More sharing options...
Pierre van Male Posted July 1, 2004 Author Share Posted July 1, 2004 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7100 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now