G Guest Apr 20, 2005 #1 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 !!!!!!!
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 Apr 20, 2005 #2 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
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
