Calculation returns null if one value is null 1

[ChrisN]

I have a query which pulls two quantity fields from different tables. If there is no related record in the second table then I cannot subtract one from the other cos the second value is null.

Basically what I want to know is, is it possible if no related records are returned to return a zero so that
A - B = A and the value I require is returned.

TIA,
Chris

 

[tlbroadbent]

Use the IsNull function to convert the Null value to Zero.

A - IsNull(B,0) Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[ChrisN]

Thanks Terry,

That worked fine. I had tried ISNULL but was missing the ',0' bit of it.

Cheers,
Chris