need to create a report. The main field is release date which can be just about any date but I only want to count the number of records by the month for the most recent 9 months. For example, if I were to run the report today it would have counts for Sept-Dec 2014 and Jan-May 2015... then when run in Oct - Sept would dropoff but June 2015 would be included.. I just need to know the number of release dates that fall within the month. There's other field/colms but got that working OK.. figure got toe do a compare for the year and month of the current date against the release date but really am a rookie and just cannot seem to get the formula to work properly. Any assistance will be very much appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
create a rolling 9 month report
- Thread starter birdie4me
- Start date
Similar threads
- Locked
- Question
- Locked
- Question