Adding a field that is blank

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

Pete Provencher

Using Access 2000:

I have two fields LandValue and ImprovementValue. I'm trying to create a new
field that adds the numbers in the two fields. Unfortunately, on of the
fields might be null and in that case is doens't add them. Is there a work
around here. I don't want to have to put a 0 in the null instances.

I thought someting like this might work but it doesn't:

((IIF([landvalue] is null,0,[landvalue])) + (IIF(impvalue] is
null,0,[impvalue])))

Any help will be appreciated.

Pete Provencher
 
Using Access 2000:

I have two fields LandValue and ImprovementValue. I'm trying to create a new
field that adds the numbers in the two fields. Unfortunately, on of the
fields might be null and in that case is doens't add them. Is there a work
around here. I don't want to have to put a 0 in the null instances.

I thought someting like this might work but it doesn't:

((IIF([landvalue] is null,0,[landvalue])) + (IIF(impvalue] is
null,0,[impvalue])))

Any help will be appreciated.

Pete Provencher
Click to expand...

See Access help on the Nz() function.
NewColumn:Nz([LandValue],0) + Nz([ImpValue],0)
 
Found the problem. Missing [ in front of impvalue]

Thanks anyway. Just knowing that the group exists to help makes learning
this stuff easier.

Pete Provencher
 
Back
Top