subrtraction - to work out variance

L

liz

I want to do A-B=C but I want the value of C to read as 0 as long as there is
no value in the B coulmn.

HELP ME !!!!!!!
 
E

Ed Warren

In a query:

SELECT A, B, IIf(IsNull()=True,0,[a]-) AS C
FROM Table1;

"in English" if the field b is null then return 0, otherwise return field
a - field b.
Query1 A B C
1 1 0
2 0 2
3
0
4 5 -1


0


Ed Warren
 
Top