I would like to create a cross tab report with our invoice history table with the month/year used as the colums. I would like to have the months lined up but I don't know if it is possible to group, for example, all invoices from 10/02 in one column, 9/02 in the next, 8/02 in the next, etc. Thanks.
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grouping By Date In Crosstab Report
- Thread starter JARNDT
- Start date
synapsevampire
Programmer
Place the date field in the crosstab column header, select Group Options and change A Column Will Be Printed for each Month, and change the order to descending if required.
-k kai@informeddatadecisions.com
-k kai@informeddatadecisions.com
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question