Re: Multiple Sum Queries

2002-04-27 Thread Paul DuBois
At 14:24 -0500 4/27/02, [EMAIL PROTECTED] wrote: >I have a table full of cell phone data with three important columns: >ServiceNumber, ratingPeriod (1,2 or 3) and minutes. I want to run a >query grouped by serviceNumber that gives me the sum of minutes per >rating period for each of the numbers

Multiple Sum Queries

2002-04-27 Thread dstark
I have a table full of cell phone data with three important columns: ServiceNumber, ratingPeriod (1,2 or 3) and minutes. I want to run a query grouped by serviceNumber that gives me the sum of minutes per rating period for each of the numbers in the other cloumns. So the query result will loo