Calculate fields

[Portucale]

Hi,

I am trying to calculate 5 fields within my table in a query, but for some reason some rows do not calculate as not all the fields contain a value (blank field), is there anyway that I could bypass this issue?

Thanks,

 

[plog]

Use an IIf (http://www.techonthenet.com/access/functions/advanced/iif.php) or NZ (http://www.techonthenet.com/access/functions/advanced/nz.php) statement to catch the blank value and implement your backup logic.