WOW!

again... WOW!!!!

Janine, i am very very grateful, and very very very impressed... i don't think i could have figured that out.

I'll buy you a drink next time i...

Hi Mahesh,

here is the report that im trying to generate:

notice how there are only Skill_Groups listed that have COUNT values for them. I also need to show Skill_Groups that do...

Actually, thinking a bit further down the track... what i am actually after is...

I have a table like this:

name, category, createdDate, status, statusDate

and i want to create a recordset like...

Hi Mahesh

thanks for your quick reply.

What you have posted is exactly what i was after. Except, it doesn't return all categories. i think it ignores Categories which have a 0...