Count Items In Recordset

Hi All,
I have a question regarding recorcounts. I have a set of records that i got after writing the sql query. The record layout is something like:

ID Amountdue
1 5
2 10
3 40
4 0
5 -6
6 230
7 -5
8 100
9 -1
10 0

I want to get the count of each amount due more than 0, less than 0 and equal to 0 all in the same query. So the result should look something like

Order PassGT0 PassLT0 PassEQ0
1 5 NULL NULL
2 NULL 3 NULL
3 NULL NULL 2

i can do 3 separate select count(*) if these were stored in a table but the result set was created using joins in the Query Analyser. I can also achieve the above result using unions with 3 separate queries with different conditions but this way i have to join the tables 3 times in each query and this is slowing down the query.

Please let me know if there is some other way i can achieve this.

Thanks