Sub-Total by Month

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
muzzy
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Sub-Total by Month

Post by muzzy » Thu Jan 03, 2002 5:49 pm

I^m new to R&R (8.0). How can I create a report that sub-totals sales by month? I can export out to Access and do it, but is there an easy way from w/i R&R.____thanks!

Eddie_Marshall
Posts: 122
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Sub-Total by Month

Post by Eddie_Marshall » Fri Jan 04, 2002 5:27 am

You can sort and group your report by month and then create a Total field totalling sales and resetting on Month.____Hope this helps.____Eddie Marshall__Technical Support__LandMaster

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Sub-Total by Month

Post by kfleming » Fri Jan 04, 2002 3:25 pm

You might also need to create a caculated field with expression:____MONTH(datefield)____If you have a date/time data field rather than a field containing just the month.____The month() function returns just the month portion of a date or date/time field.__Kathleen__R&R Support

Post Reply