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.

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.

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.

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

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

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