Produce the day?

[mariaw]

Hi again Gemma

I wonder whether I can write some sort of formula like this:

MonFTE: iif (a date between the startdate & enddate = "Monday" and isnotnull([MonHours]), "1")

and then do the same for tues - sun; the only thing I don't know how to write is the bit about picking up the date as "Monday" in between the start and end date....)

??

(the FTE means full time equivalent)

 

[gemma-the-husky]

now you have a function, you can use it in a column in a query

eg

HoursLost: hoursoff([employeeid],[absentfromdate],[absenttodate])

replace the parameters with appropriate fields. for each row in your table this will call the hoursoff function and evaluate the hours work lost.

please note this function does not allow for bank holidays etc - it assumes any absence is time lost.

 

[mariaw]

Hi Gemma

I have finally cracked it - have done a query that relates the number of hours worked per week by the employee: so that if they are off for 8 days, I change that into weeks, and then multiply the number of weeks by the number of hours an employee works per week - that seems to work.

But thanks anyway for all of your help

Maria