If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error
Hello,
I am using Access 2003 I have a query where I add three fields together into a new field in the same query, the problem is if one of the three fields don't have an amount I get this #Error. Does anyone knows how to deal with this. Thank you in advance. |
#2
|
|||
|
|||
#Error
CAM wrote:
Hello, I am using Access 2003 I have a query where I add three fields together into a new field in the same query, the problem is if one of the three fields don't have an amount I get this #Error. Does anyone knows how to deal with this. Thank you in advance. use NZ() to convert the null value to zero, then you can add it. Total: NZ([Field1],0) + NZ([Field2],0) ... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#3
|
|||
|
|||
#Error
Thanks for your help!
Cheers, "PieterLinden via AccessMonster.com" u49887@uwe wrote in message news:a8503402827a2@uwe... CAM wrote: Hello, I am using Access 2003 I have a query where I add three fields together into a new field in the same query, the problem is if one of the three fields don't have an amount I get this #Error. Does anyone knows how to deal with this. Thank you in advance. use NZ() to convert the null value to zero, then you can add it. Total: NZ([Field1],0) + NZ([Field2],0) ... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|