query calculation column

[bluedollar]

I have a select query with a number of COUNT columns. What I need is another column that performs calculations on the results of these columns.

For example I have a done1 column that is counted and a done2 column which is counted, what I need is another column (calc) in the query that produces a result subject to the following calculation:

calc column = COUNT of done1 - COUNT of done2

A worked example is shown below:

done1 done2 calc

2 1 1
0 1 -1
2 0 2

Whats the best way of doing this? Any help would be greatly appreciated.

Thanks

Dan

 

[bluedollar]

Totally disregard the above question, found how to do it on the net, I was being stupid.

Thanks

Dan