Access Query fields addition and subtraction

[mohamednoori]

Hi,

i have set up access query to add and subtract calculated fields below

NetBalIQD: [IQDOB]-[IQDMovesOUT]+[IQDMovesIN]+[exIQDIN]-[EXIQDOut]

I used function dsum so I can apply some conditions , everything works well except that I didn't get result until all fields have values [IQDOB]-[IQDMovesOUT]+[IQDMovesIN]+[exIQDIN]-[EXIQDOut] , I am new access so is what is wrong here that prevents [netBalIQD] get result but only there is values for all fields.


thank you in advance


Regards,

 

[ranman256]

If a field is null , then any math will result in null, so....
convert all fields using NZ to convert null to zero:

NZ([IQDOB])-NZ([IQDMovesOUT])+NZ([IQDMovesIN])+NZ([exIQDIN])-NZ([EXIQDOut])

 

[mohamednoori]

If a field is null , then any math will result in null, so....
convert all fields using NZ to convert null to zero:

NZ([IQDOB])-NZ([IQDMovesOUT])+NZ([IQDMovesIN])+NZ([exIQDIN])-NZ([EXIQDOut])

Thank you very much for help , you are awesome, the NZ function was what is needed to convert null to Zero.

befor I use the NZ function , whenever I click the query it crash access and exit I think this will solve this problem too .

Again thank you for help