ContributionsMost RecentMost LikesSolutionsRe: Count Work Orders Started on WeekdaysThis worked great. Thank you! ------------------------------ David Browne ------------------------------ Re: Count Work Orders Started on WeekdaysMonth([Work Order Start Date]) = Month(Today()) and DayOfWeek([Work Order Start Date]>=1 andDayOfWeek([Work Order Start Date]<=5) Its telling me ">=" can not be applied as an operator on date, number. ------------------------------ David Browne ------------------------------ Count Work Orders Started on WeekdaysI need a report formula that will count the current month's work orders that are started on weekdays only. Any ideas? This is where an am so far: IF (Month([Work Order Start Date]) = Month(Today()), Count([Work Order #])) Thanks. ------------------------------ David Browne ------------------------------ Re: Multi-user Task Manager Summary Report by UserI was thinking along those lines as well. I just don't know how to parse the names I get from UserlistToNames([Assigned To]) into separate fields. I didn't quit follow the bit about the automation deleting the children. What are the children in this case? Thanks for you help! ------------------------------ David Browne ------------------------------ Multi-user Task Manager Summary Report by UserI have a task manager in which I can assign multiple user to a single task via the [Assigned To] List-user field. So far I have not been able to make a summary report which breaks down the task assignment by individual users. For example, Bob, Mike and Jan can be assigned tasks. Bob and Mike are both assigned individual tasks, but Mike and Jan are both assigned to work another task together. Currently the summary looks like this: Assigned To # of Tasks Bob 1 Mike 1 Jan, Mike 1 I want it to look like this: Assigned To # of Tasks Bob 1 Mike 2 Jan 1 The problem I keep running into is not being able to summarize records that contain multiple values in a single field. Anyone have any creative solutions? My Project Manager sure would like to see the total amount of tasking assigned to each user at a glance. ------------------------------ David Browne ------------------------------