[thelist] Creating Reports: Where to put the logic?

[Casey Crookston]

I meant to mention, the db is MS SQL.

Thanks!

 -----Original Message-----

Hey Casey,
   Try something along these lines:

SELECT salesRep, Sum(salesAmount) AS salesTotal
 FROM sales
GROUP BY salesRep

What db are you using? SQL server? MySQL? Oracle?

Matt