Calculate Hours for Fiscal Year

[y2kmental]

In my department each member has their own time card for the fiscal year staring in July and ending in June. This time card shows how many hours they worked on a specific date, in the end it calculates the hours for the month and then year.

Please see attached PDF for a better idea of what I mean.

I have to come up with a solution that will place the appropriate number of hours worked on a specific date for each officer.

This seems awfully difficult to do, I am not even sure if it can be done. Any help would be greatly appreciated.

Thanks

APS___11.pdf

[Vaughan]

Riddle me this: I start work at 9:00 am and, because the server went down and it needed to be back up asap, I finished work at 2:00 am next morning.

Which "date" should my work hours be attributed to?

[y2kmental]

The number of hours worked, which isnt more than 16 hours per date would each have its own date.

Did you get a chance to look at the attachment?

[Vaughan]

What you want is a cross-tab report. FileMaker Pro doesn't natively do these, they have to be built-up using calculated fields (a very good use for repeating fields).

At this early stage, though, you need to be concertned about getting the underlying data structure right. IMHO it boils down to a "Days" table where each record represents the number of hours worked per day.

My earlier question is directly related to this: what happens if a person's work spans multiple days -- say with a night shift.

Getting week, month and year reports will be easy with this data structure. Getting the info into the shape you want till be quite a bit of work.

[y2kmental]

Do you think it would be more approriate to use MS Access or Excel for this kind of problem?

[comment]

I think you should describe the problem a little better. So far all we have seen is a paper form that looks like something an employee would submit once a year. I am not clear on what you have to start with, and what do you want to end up with.

[y2kmental]

Well what I would like to do is, from a promt or form, select an employees name, the date, and the hours worked. When ill need to look at that employees timesheet and print it out at the end of the year I would like all it all to come together from the prevously entered information that accumulated in the database

[comment]

Sorry, but this is still not clear. Do you have a table of Employees? And a separate, related table where each record has a Date, EmployeeID and HoursWorked?

If yes, then the only problem is how to print out the summary on the provided form?

[y2kmental]

Yes sir, thats what is so difficult, formatting it that way. I am stuck at this part, I don't know how easy it would be to make this in FM.

[comment]

Not very easy - but possible. Not exactly a task for a beginner, though, so expect to spend some time to understand how it works.

And you still have to build a list layout (based on the ReportMonths table) that will fit the form.

GridSummary.fp7.zip

[y2kmental]

Wow, how did you do that, lol? This is very nice. Hopefully I could adapt this to my project.

Now, as for the list layout, basically I have to format it to fit that form, correct?

[y2kmental]

So I am almost done adapting your template to my design. Thank you...

I am just curious if I would be able to programmatically place an X in the dates that are non existent, such as September 31, Nov. 31, Feb 30 & 31... so on.

Would such a task require a global field maybe?

Thank you

[comment]

You could place a repeating calculation field over the summary.

(I suppose 3 repetitions would have been enough, but it was quicker this way.)

GridSummary.fp7.zip

[y2kmental]

Thank you again for your help, it all seems to be coming together now.

I am just looking to make a GUI that would work well with the database.

What I am looking to do is:

On one layout:

Have one date field outside of a portal.

On the portal, have a "employee select" drop down list, with an hours field adjacent to it.

Also, something such as a simple prompt with suffice as well.

Any ideas?

Thanks

[y2kmental]

Hey you didn't happen to get around to reading my response did you?

Thanks