summing different multiple amounts with grouping

[whitesmoke]

hey all, thanks to anyone that can help

i have 5 fields facid custid empid amount invdate.

i need to be able to get totals on the amount based on fac, cust & emp based on a date range given by user, but here's the kicker.. i need to get the current month totals, month totals - 1year (so same month but for last year)
the date range totals, last yeardate range
current ytd, last ytd

i did it using code, but the performance isn't that great. there are 2800 customers it has to cycle through and figured one of the resident experts can help with a query.
i've used dsum() but not quite getting the results i should.
i think one of the problems is the user has the option of filtering the data based on the 3 fields.

anyways if you can help i'd greatly appreciate it..

 

[llkhoutx]

I group tens of thousands of rows from an Oracle server. Sometimes it taken 5 minutes or so.

You shouldn't have any trouble summing in a footer. I sum in multiple footers, suppressing the detail, i.e. without detail records.

Keep working at it. I suspect you're not summing in the correct report section. Sum in a group footer.

 

[whitesmoke]

no, i want to be able to do the grouping of sums (getting the data in the query) prior to doing the report. the problem i'm having is capturing the data from the different date ranges withing the grouping. at least that is one of my major probs.


thanks

oh and oracle yes, my life would be much easier.. access on the other hand... it takes magic sometimes!