December 28, 200619 yr I am almost done with this project. It has been a year and you guys have helped me out a lot. I have one more question. I have a created a group data report that lists the workflow (design, production and design/production), relevant information for each record in that workflow, then the subtotal for the workflow. I need to also show a monthly break down. I have a date field (01/01/2007) that contains this data for each job number when it was created. I need for the report to first group the month, then the workflow along with the job number and the total for each work flow. Example: December Design Job Number 12222 Job number 12223 Total 2 Production Job number 13333 Total 1 January Production Job Number 1444 Job Number 1555 Job Number 1666 Total 3 I keep running into a problem with the date field. I created a subsummary (leading) section above the Workflow subsummary field, but when ever I perform the sort action the month appears next to each of the Job Number section. Example: Design Job Number 12222 12/01/2006 Job number 12223 12/09/2006 Total 2 Production Job number 13333 12/20/2006 Total 1 January Production Job Number 1444 01/03/2007 Job Number 1555 01/04/2007 Job Number 1666 01/05/2007 Total 3 I need for the the date field to first convert the date 01/01/2007 to the month name and then provide the breakdown for each workflow, job number and finally the total for each. Any suggestions? Your help would be greatly appreciated.
December 28, 200619 yr Author Thank you very much. I knew I was close. I had the formula right but I needed to change the caculation result from date to text. That did the trick. Thanks again Mr. Vodka!
Create an account or sign in to comment