U
UpNCmng
I've reviewed postings and have a static query that will report
the working days between two dates. Good start, but not enough.
I'm trying to create a from where the user can enter a general date range
and get all employees who's DOB (date of birth) is within that range. Then
(or on the same form) select a beg and ending date from two drop down lists
(these lists reflect any of the stored date fields in an employee table and a
secondary table 1-many...dates like submittedDate, acceptedDate, reviewDate1,
reviewDate2, DOH, DOT, etc.)
Once these records are returned, the hopes are to use WorkingDays to
determine time it's taking for a given action and to report it and the
average. And eventually find an example of producing a graph.
Thanks for any help or suggestions.
the working days between two dates. Good start, but not enough.
I'm trying to create a from where the user can enter a general date range
and get all employees who's DOB (date of birth) is within that range. Then
(or on the same form) select a beg and ending date from two drop down lists
(these lists reflect any of the stored date fields in an employee table and a
secondary table 1-many...dates like submittedDate, acceptedDate, reviewDate1,
reviewDate2, DOH, DOT, etc.)
Once these records are returned, the hopes are to use WorkingDays to
determine time it's taking for a given action and to report it and the
average. And eventually find an example of producing a graph.
Thanks for any help or suggestions.