dealing with blank fields

[NeilT123]

I have a query which draws in results from several other queries. The result for each record would be for example Answer A, Answer B, Answer C but Answers A,B and C don't always have values so in the query some of the boxes are blank.

I want to perform a mathematical calculation on A,B and C but the calculation doesn't work if A,B and C don't have values.

What is the easiest way around this please?

 

[lupins46]

It depends on what you want the result to be if any field is blank.

One option is to use an iif() function to test the value.
iif(isnull(X),0, X*2)

If you want to treat empty values a s zeros then use nz() to convert nulls to zeros.

 

[lespaul]

or:

Nz(A, whatyouwanttheresulttobe)

Leslie

 

[NeilT123]

I checked out the Nz function as suggested and it seemed ideal. However I did have to go deep into the original query to work out where to use it but the resultant queries now work fine so thank you both.