Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group by Month

Status
Not open for further replies.

GMAN33

IS-IT--Management
Dec 4, 2002
115
US
Hi Gang,

I am working with one table, Oracle, using CR9 Pro. I need to group by user for each month that they did Data Entry. There is a Date/Time stamp {01/02/02 09:23AM} when they enter the DB. So I would like to total for each user for each month and than have a grandtotal. Something like below.

Name Jan Feb Mar Total Pages Received
Joe 2 4 6 12
Jen 1 5 2 8

Thanks for the help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top