CARLEENHOP
MIS
- Mar 7, 2010
- 61
Hi I have a date field (due date) which I have created a formula to turn the date into a month (firstly number) then turning that number into a name. I have done this so I can group by month on my report.
However when the due date is the same month within my existing grouping but has different dates within that month it is actually grouping it twice, e.g. I have two groups for June where there is a 1/6 and 5/6 date in my data instead of 1 group for june. I have checked both my formulas for the date month and name in the details section to ensure they are the same data and they are, so I have no idea why the two groupings.
Any suggestions?
Thanks
However when the due date is the same month within my existing grouping but has different dates within that month it is actually grouping it twice, e.g. I have two groups for June where there is a 1/6 and 5/6 date in my data instead of 1 group for june. I have checked both my formulas for the date month and name in the details section to ensure they are the same data and they are, so I have no idea why the two groupings.
Any suggestions?
Thanks