Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

How to Summarize Time By Employee


fperugini

This topic is 7868 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello All,

I am a beginner with FileMaker 6 and need some help with reporting.

I have a TimeCards Database which contains these fields and some others:

EmployeeID

EmployeeName

Dept

JobNo

JobName

EntryDate

TimeHourMinutes

A Form collects Entries by different Employees where they record time spent on a particular Job.

Some sample records might look like this:

"1000" "Dept 1" "John Smith" "1048" "Job No 1" "04/20/2003" "3.25

"1000" "Dept 1" "John Smith" "1055" "Job No 2" "04/20/2003" "2.0"

"1002" "Dept 2" "Mary Brown" "1048" "Job No 1" "04/19/2003" "1.5"

"1002" "Dept 2" "Mary Brown" "1055" "Job No 2" "04/20/2003" "3.25"

"1002" "Dept 2" "Mary Brown" "1060" "Job No 3" "04/21/2003" "4.0"

and so on...

I need to produce a report which Lists all the employees, and a summary of the total time they charged against all jobs, i.e.

John Smith 32.5 hours

Mary Brown 38.0 hours

and so on...

I have built a form which collects the start and end date for the report, and I placed a "Generate Report" button to produce the report.

How would I go about generating a report of this type? I just need some general ideas or approaches, and I can take it from there...

Thank you.

Link to comment
Share on other sites

This topic is 7868 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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