Jump to content
Sign in to follow this  
Tom23

Summarising totals in layouts

Recommended Posts

Hi there, I have created a database that contains personel records. I have a total number of hours worked for a given project and tasks within those projects.

I would like to be able to summarise all the hours for a given project or project task but am unsure how to begin.

Share this post


Link to post
Share on other sites

Create a table to hold the project information -- use a serial number to idetify the project records.

Put a ProjectID field in the Personnel table and enter in the serial number of the Project record.

Make a relationship betaeen the Project and Personnel tables, using the ProjectID fields. The relationship can be used to calculate the hours worked.

Share this post


Link to post
Share on other sites

Hi Vaughan, thanks for your reply. It looks like I need to be more specific with my information as I have the database setup and have the information recorded in it but cannot find a simple way to summarise the workers hours by project.

I have one table "Timesheets" and it has a number of fields that record the hours each person works each day on a given project and project code.

The fields are: Name, hours, project and projectCode.

The project and projectCode fields are setup as a value list.

What I would like to do is make a layout that summarises the total hours for each project, and also the total hours for each projectCode for each project.

Thanks for your help.

Share this post


Link to post
Share on other sites

Read up on creating Summary Retports in FMP. The layout wizard will lead you through the process.

Share this post


Link to post
Share on other sites

Thanks, had a quick look and this looks like the direction I needed.

Share this post


Link to post
Share on other sites

The good news was that you had the data structure right in the first place!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.