SELECT statement help needed.

[adavis]

I'm building a report and currently doing it the "hard way". There are so many variables in building the report that it isn't working in all cases. I have a select statement something like this:

SELECT * FROM mytable 
    WHERE CDate >= '2003-11-01' 
      AND CDate <= '2003-11-31' 
      AND (division = 'A' OR division = 'V') 
    ORDER BY Status, division, dept

.
Status will be Approved, Cancelled, Rejected.

What I want to do is count up all the departments (like A1,A2,...) that match within each division.

Is there a way to write a SELECT statement to do this?

Thanks,
casa

[LordShryku]

Not so sure I completely understand what you're looking for, but taking into consideration your current SQL, and counting by dept, division, here's my best guess

SELECT   division,
         dept, 
         count(*)
FROM     mytable 
WHERE    CDate BETWEEN '2003-11-01' AND '2003-11-31' 
AND      division IN ('A','V') 
GOURP BY dept, division

[adavis]

I figured out almost the same thing except that I decided to go with single divisions. I didn't know about the "IN" option or the 'BETWEEN' option though. I will definately use the 'BETWEEN' for the dates and I may need the 'IN' for a different report for this same project.

Thanks...