Page 1 of 1
Sub-Total by Month
Posted: Thu Jan 03, 2002 5:49 pm
by muzzy
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!
=> RE: Sub-Total by Month
Posted: Fri Jan 04, 2002 5:27 am
by Eddie_Marshall
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
==> RE: Sub-Total by Month
Posted: Fri Jan 04, 2002 3:25 pm
by kfleming
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