Calculating future Hours for Employees

[bluke]

Hi,

I'm new to this forum and to Access and need assistance writing a query that will give me employee total work hours for a range of future dates. I have an existing table with employee name, day of week, and total number of hours working for that day, in most cases 8. I need to be able to query this table for a date range so the result comes out as - between date x and date y (in the future) employee A is scheduled to work total of X hours. Is this possible? If so, how?

Thanks in advance

[June7]

Maybe. Calculate the number of work days between the two dates and multiply by hours per day. The calculation of work days will probably need a custom function so that weekends and holidays can be excluded. Calculating work days is a common topic and has been discussed in previous threads and many code samples can be found on web.

Here is one http://www.jpsoftwaretech.com/calcul...lidays-in-vba/

It hard codes the holiday dates. Alternative is a table of holiday dates.