H
hughess7
Hi, one of the tasks of my database is to track what our employees are doing
on a daily basis. Part of their activities are audits which can last 1 - 5
days as a typical scenario. I only have one record in the table for the audit
which records the start date, I then have a field 'ReviewDays' which holds
the number of days the audit lasted.
The problem I have is that I need to produce a weekly itinerary so we can
see what everyone is doing each day. I have created a crosstab query to
produce the itinerary but I would like to somehow use the 'ReviewDays' field
to display an entry in each day as opposed to just the start date. Does
anyone know if this can be done? The added complication is that the day would
have to be checked to exclude weekends as sometimes a 4 day audit could start
on a Thursday and finish on a Tuesday. I am a novice when it comes to VBA...
Any help would be most appreciated.... please
Sue
on a daily basis. Part of their activities are audits which can last 1 - 5
days as a typical scenario. I only have one record in the table for the audit
which records the start date, I then have a field 'ReviewDays' which holds
the number of days the audit lasted.
The problem I have is that I need to produce a weekly itinerary so we can
see what everyone is doing each day. I have created a crosstab query to
produce the itinerary but I would like to somehow use the 'ReviewDays' field
to display an entry in each day as opposed to just the start date. Does
anyone know if this can be done? The added complication is that the day would
have to be checked to exclude weekends as sometimes a 4 day audit could start
on a Thursday and finish on a Tuesday. I am a novice when it comes to VBA...
Any help would be most appreciated.... please
Sue