Hi,

I have a simple table shown below:

Name Exception Age
John Good 24
John fine 26
John Good 25
Peter Fine 17
Peter Good 29
Peter Good 17
Jack Good 15
Jack Good 11

I need a consolidated report which contain following information:

Number of exception done by John
Number of good exception done by John
Number of fine exception done by John

Number of exception done by peter
Number of good exception done by peter
Number of fine exception done by peter

Can this be done by querying the database. Please help me, i am stuck over
this from quite sometime.

Thanks!
Boss

I am really sorry, I posted it to the wrong place.

Sorry!
Thanks!
Boss


"Boss" wrote:

> Hi,
>
> I have a simple table shown below:
>
> Name Exception Age
> John Good 24
> John fine 26
> John Good 25
> Peter Fine 17
> Peter Good 29
> Peter Good 17
> Jack Good 15
> Jack Good 11
>
> I need a consolidated report which contain following information:
>
> Number of exception done by John
> Number of good exception done by John
> Number of fine exception done by John
>
> Number of exception done by peter
> Number of good exception done by peter
> Number of fine exception done by peter
>
> Can this be done by querying the database. Please help me, i am stuck over
> this from quite sometime.
>
> Thanks!
> Boss