Home » SQL & PL/SQL » SQL & PL/SQL » Re: Count broken down By month. URGENT!!!!!!!!!!!!!!!!!!!!!!!!!
Re: Count broken down By month. URGENT!!!!!!!!!!!!!!!!!!!!!!!!! [message #21184] Wed, 17 July 2002 09:42
Steve
Messages: 190
Registered: September 1999
Senior Member
select division, workedmon, count(*) no.employees
from divmon
group by division, workedmon;

that should work now just build it into the matrix report. the easiest way is to use the report wizard. its very easy to do, even a beginner can use the wizard.

i hope this helps

Report message to a moderator

Previous Topic: Re: Loading JPG/PICT picture files into a LONG RAW colum
Next Topic: Time between each transaction
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 23:55:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.