[QUOTE=RobTrew;125010]The [I]task[/I] table has a [I]context[/I] field, the value of which is either [I]NULL[/I] or the id of a particular context.

To count only tasks which have an assigned context, you need to add the condition [I]and (context is not null)[/I] to any [I]Select ... from task[/I] lines in the SQL.

For example:
[CODE]select "ALL ACTIONS", count(*) from task where (projectinfo is null) and (childrenCount=0);[/CODE]

could be edited to:

[CODE]select "ACTIONS WITH CONTEXTS", count(*) from task where (projectinfo is null) and (childrenCount=0) and (context is not null);[/CODE][/QUOTE]

Thanks a lot!

I think I have looked through all or most of these posts about OF statistics. They are really great and I do appreciate all the work that goes into them and helping people like myself.

What I am looking for is something that will tell me how many projects in a particular folder or simply in the selection.

The closest I came to that was the one that counted the estimated times of selected projects (sorry I don't have a link for that right now). I tried that but if there is no estimated times entered then it won't work. I would love to have a go at this but time and lack of knowledge of apple script are working against me.

Also I have noticed that most of these posts are fairly old. That either means that most people are happy with it or not interested any more?